/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

9 votes191 views3 answers
Import DB through mysql console
SQL
2 votes211 views3 answers
How do I add a user to a postgres database? cli
SQL
0 vote156 views1 answer
Dump only schema
SQL
0 vote191 views1 answer
Mysql sleep connections
SQL
1 vote180 views1 answer
Sql count value greater than
SQL
0 vote219 views1 answer
Table structure in sql
SQL
0 vote169 views1 answer
How to move a columns location in mysql
SQL
1 vote206 views1 answer
Apex run 404
SQL
0 vote161 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
3 votes167 views3 answers
Sql last week
SQL

Share