Prepare Interview

Mock Exams

Make Homepage

Bookmark this page

Subscribe Email Address

MSSQL%20Interview%20Questions%20and%20Answers

Question: How to rename databases in MS SQL Server?
Answer: If don't like the name of a database, you can change it by using the "ALTER DATABASE" statement with the following syntax:

ALTER DATABASE database_name
MODIFY NAME = new_database_name

The tutorial example below shows you how change the database name from "withoutbookdb" to "withoutbook":

ALTER DATABASE withoutbookdb
MODIFY NAME = withoutbook
GO

The database name 'withoutbook' has been set.
Is it helpful? Yes No

Most helpful rated by users:

©2024 WithoutBook