Querying database encryption status
You can check whether a database is encrypted using the DATABASE_ENCRYPTION_LEVEL() function.
Procedure
Use the DATABASE_ENCRYPTION_LEVEL() function. The function has the following return values:
▪0 - no encryption
▪1 - encrypted
Example
solsql> SELECT DATABASE_ENCRYPTION_LEVEL();
DATABASE_ENCRYPTION
-------------------
0
1 rows fetched.
See also