/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

10 votes123 views4 answers
Drop primary key
SQL
1 vote125 views2 answers
Oracle create synonym
SQL
0 vote120 views1 answer
Default column value in sql same as other column
SQL
37 votes128 views3 answers
Duplicate records in sql
SQL
65 votes293 views6 answers
Sql add column to table
SQL
9 votes173 views6 answers
Replace sql
SQL
3 votes124 views2 answers
Tsql join multiple record in one string
SQL
0 vote127 views1 answer
C# get sql min date
SQL
0 vote116 views2 answers
How do I install microsoft SQL on my Mac?
SQL
11 votes247 views2 answers
Import mysql dump command line windows
SQL

Share