In Adaptive Server 15.0.2, dbcc checkcatalog ensures that:
The corresponding base key is present in sysencryptkeys for every key copy in sysencryptkeys. If the corresponding base key is not present, Adaptive Server issues an error.
For every key copy, the corresponding uid is present in sysusers. If the corresponding uid is not present, Adaptive Server issues an error.
For every decrypt default defined on a column, that the corresponding decrypt default is present in sysobjects. If the corresponding decrypt default is not present, Adaptive Server issues an error.