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 votes365 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote344 views1 answer
How to select only the first rows for each unique value of a sql tablecolumn?
SQL
3 votes358 views2 answers
Postgres inner join vs join
SQL
4 votes302 views1 answer
Install postgres 12 on ubuntu
SQL
0 vote333 views2 answers
Sql drop view if exists
SQL
-1 vote386 views1 answer
Add 10 to all numbers in a column sql
SQL
1 vote359 views1 answer
PL SQL MODIFY COLUMN NME
SQL
3 votes324 views1 answer
Difference sql vs mysql
SQL
0 vote376 views1 answer
Postgresql inheritance
SQL
0 vote352 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL