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

11 votes202 views1 answer
Creating tables in sql with python
SQL
45 votes221 views5 answers
Grant all privileges mysql
SQL
1 vote183 views1 answer
Set statiscis on in sql server
SQL
1 vote222 views1 answer
Connect to mysql database ubuntu
SQL
1 vote198 views2 answers
Grab part of a string sql
SQL
2 votes220 views3 answers
Sql server: how to concatenate column data using comma
SQL
9 votes214 views6 answers
Check constraint in sql
SQL
10 votes203 views4 answers
Mysql if else
SQL
0 vote202 views1 answer
Like date sql server not working
SQL
0 vote193 views1 answer
Java input type sql date
SQL