Tsql rename table

Rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;

Tsql rename table

-- SQL SERVER -- don't put the schema in the 'new_name' field, otherwise your table might end up looking something like schema.schema.new_name
EXEC sp_rename 'schema.old_name', 'new_name';

Tsql rename column name

sp_rename 'table_name.old_column_name', 'new_column_name', 'COLUMN';

Source: techonthenet.com

Sql rename table

ALTER TABLE dataflair_employee
RENAME TO DataFlair_Info ;

Similar codes

1 vote178 views1 answer
How to use db.execute
SQL
0 vote191 views1 answer
Kill slow queries mysql
SQL
0 vote178 views1 answer
Sql server system messeges
SQL
1 vote190 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote174 views2 answers
Postgresql get long running queries
SQL
4 votes186 views2 answers
Mysql alter table set column unique
SQL
2 votes190 views2 answers
Mysql write into table
SQL
0 vote185 views1 answer
Sql server query database space available
SQL
0 vote190 views1 answer
Alter database name script
SQL
2 votes195 views1 answer
Alter table add column and foreign key mysql
SQL