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 vote133 views2 answers
Connect to mysql server mac terminal
SQL
1 vote137 views2 answers
Sql select only row with the max date
SQL
0 vote141 views1 answer
Drop unique
SQL
7 votes157 views3 answers
Restore postgres database from sql file
SQL
0 vote135 views1 answer
Create or replace view postgress
SQL
-1 vote135 views2 answers
First letter capital in mysql query
SQL
0 vote126 views1 answer
Restore backupfile discourse
SQL
15 votes144 views3 answers
Create table with primary key auto increment in sql
SQL
0 vote130 views1 answer
Alter precision
SQL
0 vote135 views1 answer
How to select a row in sql
SQL