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 vote196 views2 answers
SQL BULK INSERT
SQL
1 vote151 views1 answer
Convert rows to string sql server
SQL
6 votes160 views1 answer
SQL insert all columns
SQL
0 vote163 views1 answer
Install sql server windows 10
SQL
5 votes160 views2 answers
Get number of columns sql
SQL
0 vote166 views1 answer
Mysql add text to existing field
SQL
0 vote155 views1 answer
Get the previous column of a table in mysql
SQL
1 vote169 views1 answer
Sql group by sum with condition
SQL
11 votes167 views2 answers
Oracle saurce code
SQL
0 vote150 views1 answer
Get clob size oracle
SQL