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 vote160 views1 answer
Column with prefix in sql
SQL
0 vote117 views1 answer
Mysql root permission denied lost
SQL
0 vote106 views1 answer
Sql create text column limited values
SQL
0 vote97 views1 answer
Mysql percentage of total
SQL
0 vote95 views1 answer
Lister les index d'une table oracle
SQL
0 vote112 views1 answer
Mysql récupérer le code création de vue
SQL
2 votes116 views2 answers
Postgresql search all tables for column name
SQL
0 vote120 views1 answer
Mariadb create index if not exists
SQL
10 votes92 views1 answer
Oracle dependency
SQL
0 vote100 views1 answer
Mysql does collate nopad recognize space
SQL