Export (0) Print
Expand All
3 out of 8 rated this helpful - Rate this topic

Using Constraints, Defaults, and Null Values

SQL Server 2000

Planning tables requires identifying valid values for a column and deciding how to enforce the integrity of the data in the column. Microsoft® SQL Server™ 2000 provides several mechanisms to enforce the integrity of the data in a column:

  • PRIMARY KEY constraints

  • FOREIGN KEY constraints

  • UNIQUE constraints

  • CHECK constraints

  • DEFAULT definitions

  • Nullability

See Also

Data Integrity

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.