Chapter 13. Enforcing Data Integrity

Chapter 11, discussed the fundamentals of designing and creating tables. Before finalizing your table design, you must consider what data values should and should not be allowed into each column of a table and determine how the data across tables in a database may be related. Identifying valid values that can be inserted into a table and maintaining consistency among tables that have related data are the essence of data integrity. Data integrity is enforced as a means to guarantee that data is valid and consistent throughout the database tables.

This chapter discusses the various categories of data integrity and how to enforce data integrity using ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion 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.