/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 vote314 views1 answer
Mysql subtract month from timestamp
SQL
3 votes282 views1 answer
Difference sql vs mysql
SQL
9 votes286 views1 answer
Identity insert on sql server
SQL
-1 vote334 views1 answer
Create view in mysql workbench
SQL
0 vote305 views1 answer
Sqlplus change user
SQL
0 vote306 views1 answer
Add computed column to table sql server
SQL
-1 vote320 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote298 views1 answer
How to print records of employees hired in particular month in oracle
SQL
57 votes498 views6 answers
Sql alter table
SQL
19 votes302 views2 answers
Mysql add column after another
SQL

Share