Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

change column name in sql

MySQL:
ALTER TABLE Customer CHANGE Address Addr char(50);

Oracle:
ALTER TABLE Customer RENAME COLUMN Address TO Addr;
Source by popsql.com #
 
PREVIOUS NEXT
Tagged: #change #column #sql
ADD COMMENT
Topic
Name
2+1 =