Register to Better Coder! It's free.
Enjoy the premium features and succeed at every job interview.

How do you create a new database using SSMS?

Experience Level: Junior
Tags: DatabasesQuality Assurance (QA)

Answer

  1. Run SSMS
  2. Connect to a SQL Server instance
  3. Right click the Databases node within the Object Explorer
  4. Select New Database
  5. Fill-in the Database name
  6. Define where the Data files and the Log files of your newly created database will be stored
  7. Click OK

Database can also be created using query (script/programming code).

Related Databases job interview questions

Comments

No Comments Yet.
Be the first to tell us what you think.
MS SQL Server for Testers
MS SQL Server for Testers

Are you learning Databases ? Try our test we designed to help you progress faster.

Test yourself