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

3 votes330 views3 answers
How to add month in update sql
SQL
1 vote333 views2 answers
Drop function in sql
SQL
0 vote323 views1 answer
Mysql group by range
SQL
0 vote382 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote322 views1 answer
Postgresql comandos basicos
SQL
0 vote328 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
8 votes336 views3 answers
Postgres connection string
SQL
5 votes320 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote348 views1 answer
Modifier une valeur sql
SQL
1 vote372 views1 answer
Drop colum oracle 18c
SQL