When columns are encrypted by keys from other databases, unmount all interdependent databases as a set. The interdependency of the databases containing the encrypted columns and the databases containing the keys is similar to the interdependency of databases that use referential integrity.
Use the override option to unmount a database containing columns encrypted by a key in another database.
In this example, the encryption key created in key_db has been used to encrypt columns in col_db. These commands successfully unmount the named databases:
unmount database key_db, col_db
unmount database key_db with override
unmount database col_db with override
If you include with override, Adaptive Server issues a warning message, but the operation is successful.
If you do not include with override, commands fail with an error message
