MSSQL Interview Questions and Answers
Question: What is the simplest way to create a new database in MS SQL Server?Answer: The simplest way to create a new database is to use the "CREATE DATABASE" statement with this syntax:CREATE DATABASE database_name For example, run this statement: CREATE DATABASE YourDataBaseName GO A new database called "YourDataBaseName" should be created in the SQL server. Of course, YourDataBaseName database should be empty at this moment - no tables. But it should have some other data objects automatically created by the server. |
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?