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 views3 answers
Duplicate a column in sql
SQL
17 votes207 views3 answers
Postgresql version command
SQL
0 vote203 views1 answer
Which is the order of precedence among following operator IN OUT AND OR in sql
SQL
0 vote203 views1 answer
Renommer base sql
SQL
5 votes167 views1 answer
Copy table from one database to another mysql
SQL
0 vote194 views1 answer
Rabbitmq ui not working
SQL
0 vote278 views1 answer
Current month transactions in mysql
SQL
3 votes209 views2 answers
Tsql join multiple record in one string
SQL
0 vote197 views1 answer
Oracle last character of string
SQL
0 vote202 views1 answer
Uuid sqlalcomany
SQL