/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

11 votes318 views2 answers
Having in sql
SQL
0 vote305 views1 answer
SQL Server format datetime
SQL
0 vote321 views1 answer
This week mysql
SQL
28 votes300 views4 answers
Mysql delete database
SQL
0 vote347 views1 answer
Mysql query with sql to get the next row
SQL
0 vote314 views1 answer
Opensuse start MySQL
SQL
5 votes330 views6 answers
Sql foreign key
SQL
1 vote329 views1 answer
Data type and their numeric form
SQL
0 vote336 views2 answers
Py sqlite if entry exists
SQL
0 vote315 views1 answer
Postgres truncate with cascade
SQL

Share