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 vote147 views1 answer
Google sheets filter rows above current cell
SQL
0 vote149 views1 answer
Sql max min
SQL
1 vote161 views1 answer
Add current timestamp in mysql
SQL
0 vote153 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote160 views1 answer
Select year from dual oracle
SQL
0 vote181 views1 answer
A network or instance-specific error sql server
SQL
1 vote140 views1 answer
Deleting database in sql
SQL
0 vote198 views1 answer
Parent and child link in mysql
SQL
5 votes141 views2 answers
Oracle to_timestamp
SQL
0 vote156 views1 answer
Narural join
SQL