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

1 vote77 views1 answer
Unique vs distinct sql
SQL
11 votes180 views5 answers
Update table from another table mysql
SQL
5 votes111 views1 answer
Invalid column name sql
SQL
0 vote118 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
22 votes123 views3 answers
How to join three tables in sql using joins
SQL
1 vote97 views1 answer
Tsql update datetime
SQL
0 vote112 views1 answer
Luu ckeditor vao mysql
SQL
6 votes144 views3 answers
POSTGRES INSERT INTO TABLE VALUE FROM OTHER TABLE
SQL
1 vote131 views1 answer
Create index concurrently postgres
SQL
0 vote114 views1 answer
Sql server list user permissions
SQL