/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 vote212 views2 answers
Select only columns that are not empty oracle sql
SQL
4 votes200 views2 answers
Oracle sql group by date year
SQL
0 vote189 views4 answers
Postgresql between month
SQL
0 vote190 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
0 vote187 views1 answer
Add colum date in sql
SQL
2 votes198 views4 answers
Sql query interview questions
SQL
0 vote269 views1 answer
Varchar2 length in oracle
SQL
1 vote206 views1 answer
Sql server cast date dd/mm/yyyy
SQL
2 votes208 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote181 views3 answers
How to verify sequence result in oracle SQL
SQL

Share