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 vote208 views4 answers
Sql limit 1 offset 1
SQL
0 vote266 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote255 views1 answer
Cannot pip install mysqlclient
SQL
0 vote256 views1 answer
Select distinct after join
SQL
-1 vote238 views1 answer
Spring boot mysql connection properties
SQL
-1 vote240 views2 answers
Postgres autoincrement primary key
SQL
2 votes268 views2 answers
Mysql compare datetime to another datetime
SQL
-1 vote226 views3 answers
SQL to LINQ converter
SQL
1 vote225 views1 answer
Set autoincrement to 0
SQL
0 vote254 views1 answer
Oracle chain step succeeded
SQL