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 vote197 views1 answer
Mysql remove tabs from string
SQL
0 vote230 views2 answers
How to get max from each department in sql
SQL
1 vote197 views1 answer
Not exists mysql
SQL
0 vote195 views1 answer
Sqlite select split string
SQL
0 vote182 views1 answer
Output to file mysql
SQL
3 votes226 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote211 views1 answer
Postgres in operator with comma separated values
SQL
15 votes206 views5 answers
If null mysql
SQL
0 vote205 views1 answer
Normalization in database
SQL
0 vote200 views1 answer
Delete data from database sqlite android
SQL