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

1 vote166 views1 answer
Generate random data postgresql
SQL
2 votes173 views1 answer
Q operator in oracle
SQL
0 vote173 views1 answer
Drop-toys-table
SQL
0 vote149 views1 answer
Sub blocks in sql
SQL
0 vote165 views1 answer
Can we rollback in sql
SQL
2 votes177 views1 answer
Oracle list duplicates
SQL
-1 vote255 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
25 votes209 views5 answers
Mysql replace text
SQL
1 vote220 views1 answer
Postgresql pass array in function
SQL
0 vote183 views1 answer
Sql server phone constraint
SQL