/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

0 vote221 views1 answer
Oracle date summer time
SQL
4 votes258 views6 answers
Select sql
SQL
0 vote258 views1 answer
Sql quary stuf
SQL
21 votes229 views4 answers
Oracle add column
SQL
0 vote231 views1 answer
Postgresql check total storage
SQL
0 vote225 views1 answer
Sql datediff month
SQL
1 vote238 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
1 vote210 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote228 views1 answer
Max mysql
SQL
0 vote221 views2 answers
Sql searching via key word
SQL

Share