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

0 vote353 views1 answer
Console output pl sql
SQL
0 vote356 views1 answer
How to find columns with null values in sql
SQL
0 vote350 views1 answer
Mysql check datetime equals date
SQL
0 vote370 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
2 votes344 views2 answers
Install sqlalchemy
SQL
3 votes361 views2 answers
Mysql import gz
SQL
0 vote372 views1 answer
Sql server create constraint
SQL
6 votes377 views1 answer
Oracle pl sql source
SQL
7 votes348 views3 answers
Sql get last inserted row
SQL
0 vote373 views1 answer
How to check event scheduler status mysql
SQL