From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create the tables in SQL Server

Create the tables in SQL Server

From the course: Learning Relational Databases

Start my 1-month free trial

Create the tables in SQL Server

“

- [Instructor] With the fully developed model in hand to serve as the construction blueprint, creating the tables in SQL Server Management Studio becomes a simple exercise in following the established plan. To get started here, I'm going to create a new database. To do that in the Object Explorer, I'll right click on the Databases folder and choose New Database. In the New Database window, I'll go over to the Database name field, and we'll type in the database name of TwoTrees. Then I'll fill in the names for the database files that'll be created down below. We've got two files, one for the ROWS Data and one for the LOG. We'll go ahead and accept all the default options here for this database, and just press the OK button on the bottom. That'll create our new database, and we can see it over here in the Databases folder down at the bottom. If you're not seeing it, just right click on the Databases folder and choose Refresh. Then, we can expand the database open and we can go open up…

Contents