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

2 votes208 views3 answers
Application.properties spring boot mysql
SQL
0 vote233 views1 answer
Mariadb cast null to 0
SQL
2 votes228 views1 answer
Oracle list grants on package
SQL
2 votes230 views1 answer
Sql server case sensitive search
SQL
12 votes219 views6 answers
Select distinct
SQL
4 votes219 views1 answer
Oracle delete last row
SQL
0 vote229 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
10 votes239 views4 answers
SELECT FROM WHERE
SQL
0 vote228 views4 answers
First max salary in sql
SQL
0 vote242 views1 answer
Sql today at midnight
SQL