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

7 votes102 views1 answer
Sql management studio display line numbers
SQL
0 vote127 views1 answer
How to move a column to different spot mysql
SQL
0 vote118 views2 answers
Plsql regex match whole word
SQL
0 vote107 views1 answer
Sql pad left 0
SQL
-2 votes127 views1 answer
Trunc in sql
SQL
1 vote121 views1 answer
Mysql return if it contains
SQL
2 votes120 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
0 vote115 views1 answer
How to Remove milliseconds from Date time
SQL
1 vote119 views1 answer
Rows to comma separated values in mssql
SQL
0 vote140 views1 answer
Sql date with year
SQL