How do you create a new database using SSMS?
Experience Level: Junior
Tags: DatabasesQuality Assurance (QA)
Answer
- Run SSMS
- Connect to a SQL Server instance
- Right click the Databases node within the Object Explorer
- Select New Database
- Fill-in the Database name
- Define where the Data files and the Log files of your newly created database will be stored
- Click OK
Database can also be created using query (script/programming code).
Related Databases job interview questions
What is a data type?
DatabasesQuality Assurance (QA) JuniorDo you know what is a database, table and what is the difference between them?
DatabasesQuality Assurance (QA) JuniorWhat is Microsoft SQL Server?
DatabasesQuality Assurance (QA) JuniorWhat do you know about Windows authentication and Sql server authentication?
DatabasesQuality Assurance (QA) JuniorWhat is localhost?
DatabasesQuality Assurance (QA) Junior
