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 ...