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

2 votes195 views1 answer
Oracle virtual column
SQL
0 vote194 views1 answer
How to count with except in psql
SQL
3 votes177 views1 answer
Postgresql where current year
SQL
1 vote285 views1 answer
Mysql sort by date column
SQL
0 vote229 views1 answer
Microsoft word insert sql code
SQL
0 vote315 views1 answer
Import sql dump into postgresql database
SQL
16 votes207 views2 answers
Add column if not exists mysql
SQL
7 votes248 views1 answer
Xampp reset mysql
SQL
0 vote234 views1 answer
Set root password mysql xampp
SQL
0 vote316 views1 answer
Insensitive case match sqlalchemy
SQL