/SQL/Rename a column in sql server

Rename a column in sql server

Rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;

19

Modify column name in sql

ALTER TABLE `Table Name` MODIFY COLUMN `Column Name` Datatype(Size);

3

Change column name in sql

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

Oracle:
ALTER TABLE Customer RENAME COLUMN Address TO Addr;

1

Rename table sql server

exec sp_rename 'schema.old_table_name', 'new_table_name'

1

Source: stackoverflow.com

Cmd to rename a collumn name in sql

ALTER TABLE table_name RENAME COLUMN old_name TO new_name;

0

Rename a column in sql server

SQL SERVER
EXEC sp_RENAME 'TableName.OldColumnName' , 'NewColumnName', 'COLUMN'

0

Similar codes

0 vote179 views1 answer
Sql delete from with relation
SQL
-1 vote193 views1 answer
Mysql select count if contains
SQL
2 votes176 views1 answer
Postgresql change value in column
SQL
1 vote190 views1 answer
Quit mysql
SQL
6 votes139 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote186 views1 answer
Type int in mysql maxlenght
SQL
0 vote201 views1 answer
How to remove quotes from a string in ssis load file
SQL
5 votes229 views1 answer
Oracle ora-00054 resource busy
SQL
2 votes187 views1 answer
Postgresql drop primary key constraint
SQL
0 vote196 views2 answers
Amazon linux postgresql client
SQL

Share