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 vote315 views1 answer
Implicit inner join table alias
SQL
1 vote304 views2 answers
Limit sqlserver
SQL
9 votes318 views6 answers
Replace sql
SQL
2 votes293 views2 answers
Join update query in sql
SQL
0 vote300 views1 answer
Oracle synonym procedure dblink
SQL
0 vote298 views1 answer
How to use query in nosql
SQL
0 vote289 views1 answer
Oracle query to see what scema i am working in
SQL
3 votes319 views5 answers
Foreign keys
SQL
1 vote317 views3 answers
Nth highest salary
SQL
0 vote290 views1 answer
Mysql show foreign keys column
SQL