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 vote158 views3 answers
Postgres date difference seconds
SQL
0 vote178 views1 answer
Update sql sintax
SQL
20 votes157 views4 answers
Reset auto increment in MySQL
SQL
0 vote136 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
3 votes137 views1 answer
Oracle wait
SQL
1 vote155 views1 answer
Oracle turn off constraint
SQL
0 vote159 views1 answer
Sql log file inof
SQL
0 vote135 views1 answer
Get who is hired in specific month in sql
SQL
0 vote151 views1 answer
Mysql random number between 1 and 100
SQL
0 vote150 views1 answer
Hoq to import database source
SQL