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

2 votes189 views1 answer
Tcl in sql
SQL
0 vote156 views3 answers
Sql query checker
SQL
0 vote139 views1 answer
Uuid sqlalcomany
SQL
0 vote158 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote155 views1 answer
Intellij idea add mysql connector
SQL
1 vote133 views1 answer
How to get mysql db size
SQL
0 vote148 views1 answer
Plpgsql raise notice
SQL
0 vote163 views1 answer
Liquibase update row
SQL
0 vote151 views1 answer
Mysql make date from 2 column
SQL
0 vote139 views1 answer
Min:sec datediff mssql
SQL