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 vote141 views2 answers
Starting mysql service from mac
SQL
0 vote194 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote133 views1 answer
Sql database connectivity
SQL
1 vote139 views1 answer
Not exists mysql
SQL
0 vote145 views1 answer
Mysql reset wp_options
SQL
6 votes173 views2 answers
Oracle compile trigger
SQL
3 votes204 views2 answers
Oracle privileges users
SQL
3 votes150 views2 answers
Postgres alter table owner
SQL
0 vote137 views1 answer
Qt qsql check if table exist
SQL
0 vote136 views2 answers
Homebrew nysql launch
SQL