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 vote108 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote103 views1 answer
Sql not exists
SQL
3 votes53 views2 answers
Mysql sum with condition
SQL
0 vote119 views1 answer
Sql today at midnight
SQL
3 votes142 views3 answers
Create table in SQL Server
SQL
3 votes64 views1 answer
If 0 return null else return query mysql
SQL
0 vote112 views2 answers
Mysql missin expression near on
SQL
0 vote108 views1 answer
Date on SQL
SQL
0 vote218 views1 answer
Python get backup of sql
SQL
0 vote115 views1 answer
Sqlite3 pragma foreign keys
SQL