Answers for "changea coumn name sql query"

SQL
0

how to change column name in sql

ALTER TABLE Student RENAME COLUMN NAME TO FIRST_NAME;
ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);
Posted by: Guest on January-07-2021
-1

change name of colum in sql table

ALTER TABLE "table_name" RENAME COLUMN "column 1" TO "column 2";
Posted by: Guest on September-11-2020
1

change column name in sql

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

Oracle:
ALTER TABLE Customer RENAME COLUMN Address TO Addr;
Posted by: Guest on February-06-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language