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

13 votes97 views5 answers
Alter table query sql server change column
SQL
1 vote137 views1 answer
How do you use sql in you company
SQL
0 vote104 views2 answers
MySQL top percent
SQL
2 votes120 views1 answer
Where clause for child record apex
SQL
1 vote101 views1 answer
Floor function in sql oracle
SQL
0 vote117 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote110 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote93 views1 answer
Compare field sql server
SQL
8 votes106 views2 answers
Mysql grant all privileges to user from any host
SQL
-1 vote106 views5 answers
Not in sql
SQL