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 vote162 views1 answer
Sql how to display two atributes as one in sql
SQL
5 votes162 views1 answer
How to check port number for postgresql
SQL
3 votes180 views1 answer
DB: in eloquent using sql
SQL
1 vote166 views1 answer
Sql select contem uma palavra
SQL
2 votes214 views3 answers
How to replace null values in sql
SQL
0 vote176 views1 answer
Postgres select from values
SQL
7 votes171 views2 answers
Show size database mysql
SQL
0 vote191 views2 answers
Pl sql auto increment
SQL
0 vote229 views1 answer
Reindexing all tables sql server
SQL
3 votes178 views2 answers
Postgres show table schema
SQL