Use this clause to specify the name of the database to copy (oldfile).
Use this clause to specify the encryption key needed to decrypt the database. You do not specify the KEY clause if the
existing database was encrypted with simple encryption, which does not require a key.
The CREATE DECRYPTED DATABASE statement produces a new database file (newfile), and does not replace or remove the original database file (oldfile).
All encrypted tables in oldfile are not encrypted in newfile, and table encryption is not enabled.
For databases created with SQL Anywhere 12, the ISYSCOLSTAT, ISYSUSER, and ISYSEXTERNLOGIN system tables always remain encrypted
to protect the data from unauthorized access.
If oldfile uses a transaction log or transaction log mirror, the files are renamed newfile.log and newfile.mlg, respectively.
If oldfile contains dbspace files, a D (decrypted) is added to the file name. For example, when you execute the CREATE DECRYPTED DATABASE
statement, if oldfile is mydbspace.dbs, newfile becomes mydbspace.dbsD.
You cannot execute this statement on a database that requires recovery. This statement is not supported in procedures, triggers,
events, or batches.