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 vote264 views1 answer
Kotlin sqlite delete row
SQL
7 votes260 views3 answers
Postgre describe table
SQL
2 votes314 views2 answers
Select sqlite3.OperationalError: no such column:
SQL
0 vote265 views1 answer
Mysql wsrep ls
SQL
0 vote293 views2 answers
How to prevent sql injection in java
SQL
0 vote279 views1 answer
Mysql locate
SQL
0 vote257 views1 answer
Create table Statement Syntax in SQL Server
SQL
8 votes280 views5 answers
Grant permission in postgres
SQL
0 vote301 views1 answer
Dataframe lambda elif
SQL
3 votes299 views1 answer
Where id is in list sql
SQL