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

6 votes257 views2 answers
Install psql mac
SQL
27 votes331 views3 answers
Mysql delete row
SQL
2 votes205 views1 answer
How to make multiple keys as primary in bdms
SQL
1 vote180 views1 answer
Login to database mysql terminal
SQL
6 votes246 views2 answers
WHERE value IS sql
SQL
1 vote193 views1 answer
ORA-01950
SQL
0 vote219 views1 answer
Sql query wordpress export post
SQL
0 vote191 views1 answer
Mysql change default collation
SQL
2 votes353 views1 answer
How to create sql database
SQL
1 vote194 views2 answers
Install mysqldump ubuntu
SQL