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:
- What is Microsoft SQL Server?
- What is the simplest way to create a new database in MS SQL Server?
- How to delete a database in MS SQL Server?
- How to download and install Microsoft .NET Framework Version 2.0?
- How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?