/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

2 votes336 views3 answers
Xampp mysql database not starting
SQL
1 vote343 views1 answer
Create email address from first and last name in sql
SQL
3 votes320 views3 answers
Stop mysql ubuntu
SQL
0 vote333 views1 answer
Dual in db2
SQL
0 vote294 views1 answer
Reset keys in sql
SQL
0 vote293 views1 answer
Opensuse stop MySQL
SQL
0 vote292 views1 answer
Create new schema mysql
SQL
0 vote324 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote292 views1 answer
Mysql workbench indent formatting
SQL
0 vote334 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL

Share