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

21 votes183 views4 answers
Oracle add column
SQL
0 vote175 views1 answer
Insert overwrite table in mysql in nifi
SQL
1 vote247 views1 answer
Show databases mysql docker
SQL
0 vote156 views1 answer
Sql cross apply vs join
SQL
1 vote242 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote176 views1 answer
Mysql set variable to today's date
SQL
4 votes163 views3 answers
Mysql update with join
SQL
0 vote176 views1 answer
Flask sqlalchemy remove duplicates
SQL
3 votes176 views1 answer
Sql cast to integer
SQL
2 votes171 views1 answer
Mysql clear screen
SQL