O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

Defining Table Constraints

Constraints provide a means to enforce data integrity. In addition to NULL/NOT NULL, discussed earlier in this chapter, SQL Server provides five constraint types: PRIMARY KEY, FOREIGN KEY, UNIQUE, CHECK, and DEFAULT. These constraints help further define the type of data you can store in tables.

Constraints are covered in detail in Chapter 22, “Implementing Data Integrity.” This chapter introduces the basic means for adding constraints to a table. You can add constraints at the time of table creation, or you can add them after a table has been created by using the ALTER TABLE statement.

Listing 20.11 shows a CREATE TABLE statement that has an example of each one of the five constraint types listed. The PRIMARY KEY ...

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