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 vote243 views1 answer
What is the difference between now() and current_date()?
SQL
0 vote229 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote185 views1 answer
How to get last client id sql
SQL
1 vote290 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote235 views2 answers
Get all index postgres
SQL
0 vote264 views1 answer
Delete hangfire retries list
SQL
0 vote254 views1 answer
How to get nth number in sql
SQL
0 vote260 views1 answer
Ansi sql count duplicate rows
SQL
1 vote237 views1 answer
Pentaho + pasar de excel a sql
SQL
4 votes232 views2 answers
Mysql select where starts with
SQL