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 vote287 views1 answer
Inserted row count tsql
SQL
2 votes288 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
0 vote281 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
5 votes277 views1 answer
Mysql get last day of month
SQL
-1 vote339 views4 answers
Full outer join in sql
SQL
0 vote303 views1 answer
Sqlalchemy orm duplicate
SQL
9 votes300 views3 answers
Mysql show table column full description
SQL
0 vote297 views1 answer
Database xml sql
SQL
1 vote280 views2 answers
Setval max id postgresql sequence
SQL
1 vote334 views1 answer
UseSqlServer no definition
SQL