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 vote195 views1 answer
Backup a table in sql
SQL
7 votes183 views1 answer
Forge server hosting
SQL
0 vote244 views1 answer
Renommer schema sql
SQL
0 vote196 views1 answer
How to print out column name differently in mysql
SQL
0 vote197 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
2 votes302 views1 answer
Oracle run_duration to number
SQL
0 vote232 views1 answer
Search column name sql
SQL
11 votes204 views2 answers
Having in sql
SQL
2 votes208 views2 answers
Mamp connect mysql terminal
SQL
0 vote249 views1 answer
Sql check if field is not null
SQL