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 vote156 views1 answer
Clear screen command in psql
SQL
0 vote181 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote155 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote164 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote164 views1 answer
Mysql docker image arjun
SQL
0 vote161 views2 answers
Mysql multiply
SQL
4 votes166 views2 answers
Sql offset
SQL
3 votes166 views1 answer
Sql double index
SQL
0 vote167 views1 answer
Geopoint from json mysql function
SQL
0 vote166 views1 answer
Mysql average from two table
SQL