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 vote185 views1 answer
Use between operator in mysql
SQL
0 vote292 views1 answer
Drop check command
SQL
0 vote196 views1 answer
Mysql root localhost run
SQL
0 vote191 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
1 vote238 views1 answer
Sql query row number group by
SQL
1 vote180 views3 answers
What is union in sql
SQL
0 vote227 views1 answer
Sql select merge multiple values
SQL
0 vote185 views1 answer
Sql alternative to max statement
SQL
2 votes304 views1 answer
Postgresql group by month and year
SQL
10 votes169 views1 answer
Create table oracle
SQL