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

1 vote290 views2 answers
Create a unqie constraint mysql
SQL
0 vote297 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote311 views1 answer
Insert or update sql query
SQL
0 vote296 views1 answer
Shell script to log mysql cpu usage
SQL
-1 vote280 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote286 views1 answer
Oracle create table auto generated primary key
SQL
0 vote287 views1 answer
Oracle search columns in schema
SQL
0 vote277 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote332 views1 answer
Mysql average from two table
SQL
1 vote287 views1 answer
Lpad function in sql oracle
SQL