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 vote371 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote317 views2 answers
Mysql show views
SQL
2 votes321 views1 answer
Postgresql create schema in specific database
SQL
1 vote333 views3 answers
Rows, INSERT INTO
SQL
10 votes331 views4 answers
Primary key in sql
SQL
0 vote286 views0 answer
SQL
1 vote309 views1 answer
Sql server locks
SQL
0 vote322 views2 answers
Postgresql change user role grant
SQL
0 vote329 views1 answer
Logtash mysql cofiguration file
SQL
1 vote305 views2 answers
Postgresql list columns
SQL