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

12 votes255 views10 answers
Google
SQL
2 votes246 views1 answer
Anonymous block plsql
SQL
1 vote237 views1 answer
Oracle current sequence value
SQL
1 vote246 views1 answer
Mysql connect command
SQL
1 vote286 views1 answer
Sql row having max
SQL
2 votes253 views1 answer
Tsql copy table
SQL
2 votes298 views2 answers
Null column to 0 in mysql
SQL
3 votes253 views1 answer
Select table column in sql
SQL
0 vote283 views1 answer
Mysql 3 months ago
SQL
1 vote277 views1 answer
Write a query to create an empty table from an existing table?
SQL