Using SSMS to Create a Database
The Object Explorer in SSMS makes creating a database simple. You right-click the Databases node and select New Database. The New Database dialog appears, as shown in Figure 20.2. The General page is selected by default. It allows you to select the essential information needed to create a database, including the database name, database owner, and location of the database files.
FIGURE 20.2 Creating a database by using SSMS.
Some related information is populated when you enter the database name. For example, the default logical names and locations of the database files are populated using the database name. The ...
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
