June 2006
Beginner
456 pages
10h 3m
English
After you have created a database, you are ready to add other objects to it. Generally, the first objects that you add to a database are the tables that it contains. In this hour you’ll learn:
• How to create SQL Server tables
• How to work with identity columns
• How to work with computed columns
• How to work with user-defined data types
• How to add and modify indexes
Tables are made up of rows and columns. We refer to columns as fields. Each field has a unique name and contains a specific piece of information about the row. Each table in a SQL Server database must have a unique name.
To create a table, follow these steps:
1. Within Management Studio, right-click ...
Read now
Unlock full access