The SHOW ENCRYPT statement provides encryption policy information on the primary database. It can be used only by security administrators or DBAs. It uses the following syntax:

 SHOW ENCRYPT ON { ALL [ TABLE |INDEX |LOB ]
                 | TABLE table_name[ WITH INDEX |WITH LOB ]
                 | TABLE table_name ON INDEX index_name}  
;

When run, the statement returns a result set with eight columns:

  • Database object type (AREA, TABLE, INDEX, LOB)
  • Database object name
  • Objects table name (blank for area)
  • Database object name (blank for area)
  • Database object identification
  • Object policy state (CURRENT or PREVIOUS)
  • Object policy cipher name
  • Object policy version number

Only active policies are returned by the statement. The only option which shows Type I area encryption information is the SQL statement SHOW ENCRYPTION ON ALL. Other options on SHOW ENCRYPT show encryption information only for Type II area database objects.