Connect to an existing database from Interactive SQL.

Decrypt the database using the CREATE DECRYPTED DATABASE statement.

The first statement creates an AES256-encrypted copy of the demo.db database called demoEncrypted.db,. The second statement creates a decrypted copy of demoEncrypted.db called demoDecrypted.db.

CREATE ENCRYPTED DATABASE 'demoEncrypted.db'
   FROM 'demo.db'
   KEY 'Sd8f6654*Mnn'
   ALGORITHM 'AES256';
CREATE DECRYPTED DATABASE 'demoDecrypted.db'
   FROM 'demoEncrypted.db'
   KEY 'Sd8f6654*Mnn';

If there are transaction logs, transaction log mirrors, or dbspaces associated with the database, decrypted copies of those files are made as well. See CREATE DECRYPTED DATABASE statement.