When columns are encrypted by keys from other databases, unmount all related 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.
With the following commands, 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 the with override option, Adaptive Server issues a warning message, but the operation is successful.
These commands fail with an error message without the override:
unmount database key_db unmount database col_db
