Chapter 5. Creating your first table
After completing this chapter, you will be able to
Develop a naming standard.
Understand schemas.
Understand the different SQL Server data types.
Understand column properties.
Create and alter tables.
Understand computed columns.
Add constraints to a table.
Understand the FileTable feature.
Create a database diagram.
Just as the database is the primary container of all objects on an instance of Microsoft SQL Server, the table is the primary container of all data on a SQL Server instance. Tables are the foundation of all objects, and without them a database is useless. The power in any application is the data that it accepts and stores. Without a relational database management system (RDBMS) to store and maintain that ...
Get Microsoft® SQL Server® 2012 Step by Step 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.
