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 vote237 views1 answer
PSQL qith variables
SQL
2 votes236 views1 answer
Laravel sql String
SQL
10 votes223 views3 answers
Sql limit results
SQL
0 vote239 views1 answer
Oracle temporary table
SQL
11 votes227 views2 answers
Safe mode off mysql
SQL
0 vote274 views1 answer
Influxdb list all tags for a measurement
SQL
2 votes238 views1 answer
Sql column values comma separated
SQL
0 vote230 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote241 views1 answer
Mysql not defined
SQL
2 votes229 views2 answers
Mamp connect mysql terminal
SQL