Answers for "alter table rename column name"

sql rename column

-- Oracle, MySQL 8+
ALTER TABLE table_name RENAME COLUMN current_name TO new_name;
-- MySQL < 8:
ALTER TABLE table_name CHANGE current_name new_name datatype(length);
-- SQL Server:
EXEC SP_RENAME 'table_name.current_name' , 'new_name', 'COLUMN'

Posted by: Guest on May-04-2021

Code answers related to "alter table rename column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table rename column name"

Code answers related to "alter table rename column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table rename column name"

Code answers related to "alter table rename column name"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us