Rename database in sql

Rename table sql

ALTER TABLE STUDENTS  
RENAME TO ARTISTS;

Rename database in sql

RENAME DATABASE  MODIFY NAME=emptestdb;

Source: tutorialscampus.com

Alter database name script

USE master;  
GO  
ALTER DATABASE MyTestDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE MyTestDatabase MODIFY NAME = MyTestDatabaseCopy ;
GO  
ALTER DATABASE MyTestDatabaseCopy SET MULTI_USER
GO

Rename command in sql

Alter table

Similar codes

0 vote163 views1 answer
Heidisql check how much space a row
SQL
0 vote196 views1 answer
Postgres - Login and connect as default user
SQL
0 vote165 views2 answers
Search stored procedures
SQL
0 vote170 views1 answer
Set a default value for a column in sqlite
SQL
9 votes194 views3 answers
Find all tables with column name
SQL
1 vote168 views1 answer
Find a column in all tables postgres
SQL
0 vote175 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote137 views1 answer
Query for maximum salary
SQL
3 votes162 views1 answer
Oracle failed login attempts
SQL
0 vote216 views1 answer
SQL SERVER Add Identity Column to existing table
SQL