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 vote256 views0 answer
SQL
5 votes304 views1 answer
Sql table columns
SQL
0 vote286 views1 answer
Sql count null values in all columns
SQL
0 vote236 views1 answer
Get last run query sql server
SQL
19 votes297 views3 answers
How to change column type psql
SQL
2 votes268 views1 answer
Sqlite show table indexes
SQL
0 vote288 views1 answer
Mysql isshow
SQL
-1 vote281 views1 answer
Mac mysql workbench console
SQL
0 vote288 views1 answer
Oracle table free space
SQL
0 vote268 views3 answers
Sql select statements
SQL