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 votes177 views3 answers
Sql average
SQL
25 votes209 views1 answer
How to update an attribute in MySQL
SQL
0 vote187 views1 answer
Sql select by content lenght
SQL
0 vote168 views2 answers
How to start postgresql laravel
SQL
0 vote184 views1 answer
Postgresql delete multiple rows
SQL
1 vote214 views1 answer
Oracle list data files
SQL
1 vote182 views1 answer
Spring postgresql reset auto increment to 0
SQL
0 vote206 views1 answer
Sql last time database was accessed
SQL
11 votes189 views2 answers
MySQL DISTINCT
SQL
0 vote136 views1 answer
Mssql view column data type
SQL