/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 vote107 views1 answer
Psql show with user is logged in
SQL
-2 votes111 views1 answer
Mysql see users and passwords
SQL
0 vote66 views1 answer
Select all domains of database firbird
SQL
0 vote117 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote124 views1 answer
How to fetch alternate records from two tables
SQL
1 vote107 views1 answer
SQL server query column yes or no
SQL
-1 vote109 views3 answers
Create temp table in sql
SQL
0 vote126 views1 answer
Sql values that contains certain multiple ids
SQL
0 vote106 views1 answer
Insert thai language sql server
SQL
24 votes112 views4 answers
How to add column sql
SQL

Share