Answers for "alter table ALTER 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

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

Code answers related to "alter table ALTER COLUMN NAME"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table ALTER COLUMN NAME"

Code answers related to "alter table ALTER COLUMN NAME"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table ALTER COLUMN NAME"

Code answers related to "alter table ALTER COLUMN NAME"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us