dbcc checkcatalog includes the following additional consistency checks:
For each encryption key row in sysobjects, sysencryptkeys is checked for the existence of a row defining that key.
For each column in syscolumns marked for encryption, the existence of the key is checked in sysobjects and sysencryptkeys.
