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

13 votes348 views5 answers
Select last row mysql
SQL
0 vote367 views1 answer
Hibernate show sql xml property
SQL
1 vote328 views1 answer
Mysqli connect
SQL
0 vote373 views2 answers
How to prevent sql injection in java
SQL
0 vote350 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote363 views1 answer
How to know if table in rigt or left in sql
SQL
2 votes374 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote341 views1 answer
Sql counter column
SQL
0 vote337 views1 answer
Sql remove last x char
SQL
0 vote346 views1 answer
Hive batch drop table
SQL