Cross-Table Consistency Checks
Cross-table consistency checks involve validating nonphysical relationships between various tables in the database. Some examples are
The metadata for a table must have matching metadata describing its columns (the two sets of data are stored in different system catalogs).
A primary XML index must be an accurate representation of the XML column that it indexes (a primary XML index is stored as an internal table, separate from the table containing the XML column it indexes).
An indexed view must be an accurate representation of the view definition (an indexed view is stored as an internal table, separate from the tables referenced in the view definition).
These cross-table consistency checks cannot be run unless the tables ...
Get Microsoft® SQL Server® 2008 Internals 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.
