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

3 votes140 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote182 views1 answer
SQL SERVER Add Identity Column to existing table
SQL
0 vote130 views1 answer
Psql check if value in array
SQL
3 votes173 views1 answer
Mysql cli connect with password
SQL
2 votes162 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote160 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
5 votes164 views1 answer
Oracle sysdate - 1 month
SQL
2 votes142 views1 answer
Date conversion in mysql column
SQL
3 votes144 views3 answers
Update join
SQL
3 votes133 views2 answers
Oracle sql truncate table
SQL