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

3 votes308 views2 answers
Oracle privileges users
SQL
1 vote293 views1 answer
Postgres convert exisiting column to text
SQL
0 vote288 views1 answer
Update using case in mysql
SQL
0 vote289 views1 answer
Mysql grant user wildcard database
SQL
17 votes297 views3 answers
Postgresql version command
SQL
1 vote289 views4 answers
Postgres extract date from timestamp
SQL
0 vote288 views1 answer
Difference between varchar and varchar2
SQL
0 vote313 views1 answer
Oracle swap partition
SQL
4 votes273 views1 answer
SQL order random
SQL
0 vote281 views1 answer
Postgresql update to unique
SQL