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 vote263 views1 answer
Difference between db.query and db.execute
SQL
0 vote276 views1 answer
Create function in microsoft sql server
SQL
8 votes260 views1 answer
Database backup in mysql server recovery
SQL
25 votes282 views6 answers
How to change column name in mysql
SQL
0 vote298 views1 answer
Select * from mysql.proc
SQL
1 vote265 views1 answer
Sql in array query
SQL
0 vote252 views1 answer
Sql select column names starting with
SQL
1 vote256 views1 answer
Check message id sql server
SQL
5 votes249 views3 answers
Mysql check if null or empty string
SQL
10 votes256 views6 answers
Between sql
SQL