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 vote121 views1 answer
Oracle list subpartitions
SQL
0 vote133 views1 answer
List all functions and procedures in postgres query
SQL
0 vote147 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote114 views1 answer
Call procedure in wordpress
SQL
0 vote130 views1 answer
Oracle drop type
SQL
0 vote158 views1 answer
Example of sql querry result sepapreted by comma
SQL
0 vote143 views1 answer
Oracle change password expiration policy
SQL
0 vote123 views1 answer
Sql constarint
SQL
1 vote120 views1 answer
PLS-00225 type
SQL
0 vote135 views1 answer
Sql select where more than one record exists
SQL