HOUR 4. SQL Server Tables
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
Creating SQL Server Tables
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 ...
Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours 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.
