O'Reilly logo

Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012 by Dejan Sarka Itzik Ben-Gan and Ron Talmage

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Creating Tables and Enforcing Data Integrity

Exam objectives in this chapter:

  • Create Database Objects

    • Create and alter tables using T-SQL syntax (simple statements).

    • Create and modify constraints (simple statements).

Tables are the primary method of data storage in Microsoft SQL Server. To use tables, you need to master how to create them, in addition to adding constraints to protect the integrity of the stored data. In this chapter, you learn how to create and alter tables, in addition to enforcing data integrity between tables by using table constraints.

Lessons in this chapter:

Before You Begin

To complete the lessons in this chapter, you must have:

  • An understanding ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required