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 vote193 views1 answer
R2dbc-postgresqldriver dependency
SQL
10 votes189 views2 answers
Linux command line import mysql database
SQL
0 vote192 views1 answer
Sql combine results from two tables
SQL
0 vote184 views1 answer
Mysql_num_fields in mysqli
SQL
1 vote202 views1 answer
Oracle drop chain step
SQL
6 votes209 views2 answers
Postgresql database url
SQL
2 votes194 views1 answer
Delete all value query
SQL
8 votes230 views2 answers
Oracle undo usage
SQL
25 votes184 views1 answer
Mysql grant all privileges to a user
SQL
0 vote208 views1 answer
Postgresql auto increment not working
SQL