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 vote161 views1 answer
Sql last 3 rows
SQL
0 vote153 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote138 views1 answer
Remove binlog mysql
SQL
0 vote149 views1 answer
Will graphql replace sql
SQL
15 votes264 views3 answers
Postgresql change column type
SQL
0 vote175 views1 answer
Mysql sum per week
SQL
16 votes142 views2 answers
Add column to all tables after first column mysql
SQL
0 vote154 views1 answer
Less than and between in sql query
SQL
0 vote140 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
0 vote142 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL