/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

1 vote105 views3 answers
Reset sql primary key
SQL
2 votes161 views5 answers
Install postgresql 10 centos 7
SQL
1 vote102 views1 answer
Get table column names sql ssms
SQL
2 votes107 views1 answer
Mysql sysdate - 1 day
SQL
0 vote103 views1 answer
Data structures in sql
SQL
1 vote92 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
0 vote104 views1 answer
Sql server select record with max id
SQL
1 vote115 views5 answers
What is in operator in sql
SQL
0 vote68 views1 answer
Sqlalchemy existing database
SQL
1 vote102 views1 answer
Mysql find tables with column name
SQL

Share