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 vote175 views1 answer
Mysql terminal list table
SQL
0 vote176 views1 answer
How to write if case in select query in select statement
SQL
0 vote225 views1 answer
Oracle temporary table
SQL
2 votes198 views1 answer
Column names in oracle sql
SQL
2 votes176 views1 answer
Enum in SQL Server
SQL
7 votes178 views5 answers
Oracle alter table
SQL
1 vote176 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
0 vote227 views1 answer
Postgres get running query
SQL
11 votes163 views2 answers
Oracle all source
SQL
1 vote162 views1 answer
Oracle aleter trigger ora-01031
SQL