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

32 votes337 views6 answers
Insert into values select
SQL
0 vote339 views1 answer
Mysql where in keep order
SQL
1 vote341 views1 answer
Psql search table
SQL
8 votes336 views3 answers
Oracle auto_increment
SQL
0 vote306 views1 answer
Mysql with
SQL
2 votes329 views1 answer
Oracle sql day of month from date
SQL
6 votes360 views2 answers
Mysql execute file
SQL
0 vote390 views1 answer
Site:av.ru "files"
SQL
0 vote364 views1 answer
How to get table id sequence postgres
SQL
8 votes324 views1 answer
Database backup in mysql server recovery
SQL