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 vote250 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote280 views1 answer
Sintaxis SELECT sql
SQL
0 vote312 views1 answer
Fetching data from mysqldb
SQL
0 vote279 views1 answer
How to select a row in sql
SQL
2 votes317 views3 answers
How to replace null values in sql
SQL
2 votes270 views1 answer
Mysql query unique column
SQL
0 vote229 views1 answer
Jooq finding lastest value in table
SQL
6 votes260 views1 answer
Allsource oracle
SQL
0 vote273 views2 answers
Sql query for getting details by id
SQL
1 vote284 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL