This topic has not yet been rated - Rate this topic

Enforcing Data Integrity

SQL Server 2008 R2

SQL Server 2008
SQL Server 2005

Planning and creating tables requires identifying valid values for the columns and deciding how to enforce the integrity of the data in the columns. SQL Server provides the following mechanisms to enforce the integrity of the data in a column:

PRIMARY KEY Constraints
FOREIGN KEY Constraints
UNIQUE Constraints
CHECK Constraints
DEFAULT Definitions
Allowing Null Values

Concepts

Data Integrity

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ