/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 vote364 views1 answer
Start stop mysql linux
SQL
0 vote378 views1 answer
Sql declare variable single line
SQL
17 votes323 views2 answers
How to assign date field for table in mysql
SQL
2 votes363 views1 answer
Mysql clear screen
SQL
6 votes352 views3 answers
Commit in sql
SQL
0 vote351 views1 answer
Mysql join same table multiple times group by
SQL
0 vote361 views1 answer
QCompleter con sql
SQL
3 votes364 views5 answers
Foreign keys
SQL
2 votes344 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
6 votes359 views1 answer
Phpmyadmin password root
SQL

Share