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 votes191 views2 answers
Insert multiple rows from another table sql
SQL
0 vote191 views1 answer
Insert set mysql
SQL
0 vote197 views1 answer
Sql include rows with 0 values
SQL
0 vote193 views1 answer
Postgres enumerated type
SQL
0 vote193 views2 answers
Sqlite unix timestamp
SQL
1 vote224 views1 answer
Mysql view current queries
SQL
2 votes211 views3 answers
Sql interview query questions
SQL
0 vote219 views1 answer
Check if mysql db is used
SQL
0 vote197 views1 answer
Utiliser sql ligne de commande
SQL
1 vote186 views1 answer
Oracle select first result
SQL