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 vote338 views1 answer
Ms Sql set us timezone
SQL
5 votes364 views1 answer
How to use rank function in sql
SQL
0 vote465 views1 answer
Drop table BigQuery table columns
SQL
0 vote365 views2 answers
Dbms interview questions
SQL
11 votes364 views1 answer
Oracle view ddl
SQL
0 vote366 views1 answer
Sintaxis SELECT sql
SQL
4 votes399 views1 answer
What are the data types
SQL
0 vote391 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
4 votes347 views3 answers
Mysql varchar length
SQL
-1 vote397 views3 answers
PS5
SQL