From the course: Microsoft SQL Server 2019 Essential Training

Unlock the full course today

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

Table structures

Table structures - SQL Server Tutorial

From the course: Microsoft SQL Server 2019 Essential Training

Start my 1-month free trial

Table structures

“

- Before we can start adding data to our database, we need to give it a structured place to go. This means it's time to create a table. Tables in a SQL Server database are created by defining the columns of information that you want to store. These columns called fields break down the details about your data into individual attributes. Then later, once your table is created, you can start adding in your data. This creates horizontal rows called records and each record will be made up of the values stored in the columns. For maximum flexibility later, it's in your best interest to break down attributes into the smallest components possible. For instance, when storing the address of your customers, you'll want to separate column for their house number and street, one for the city, one for the state, and one for the postal code. By breaking the data out into discrete components it makes it easy to search the data later and find all the customers that live in the state of California, for…

Contents