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

6 votes121 views1 answer
Oracle trigger after logon on database
SQL
0 vote130 views1 answer
Oracle sql date winter time
SQL
16 votes119 views1 answer
Mysql mediumint max value
SQL
0 vote250 views1 answer
Multiple row join
SQL
1 vote120 views1 answer
Sql myisam vs innodb
SQL
1 vote207 views3 answers
Showing all columns in an sqlite table
SQL
0 vote141 views1 answer
Compression of dabatase mysqldumo
SQL
2 votes133 views1 answer
Node and mysql like
SQL
0 vote113 views1 answer
Running query in redshift
SQL
0 vote124 views1 answer
Show function mysql
SQL