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 vote149 views1 answer
Exit psql
SQL
0 vote144 views1 answer
Import all databases mysql
SQL
15 votes182 views4 answers
Mysql export database command line
SQL
0 vote158 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
2 votes144 views4 answers
Check timezone of mysql database
SQL
0 vote159 views2 answers
How to get max from each department in sql
SQL
0 vote152 views1 answer
Can we rollback data that are deleted using DELETE
SQL
2 votes107 views4 answers
Mysql change database character set to utf8mb4
SQL
2 votes142 views3 answers
Write sql query to find the second highest salary of employee
SQL
2 votes139 views1 answer
Oracle calculated column
SQL