Answers for "change name in sql"

sql rename column

EXEC SP_RENAME 'TABLE_NAME.OLD_COLUMN_NAME','NEW_COLUMN_NAME'

Posted by: Guest on May-07-2020

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

change column name sql

ALTER TABLE `db_name`.`table_name` 
	CHANGE `current_column_name` `new_column_name` datatype(size) NOT NULL COMMENT '';

Posted by: Guest on December-06-2020

modify column name in tsql

sp_rename 'table_name.old_column', 'new_name', 'COLUMN';

Posted by: Guest on May-08-2020

Code answers related to "change name in sql"