Use an encryption key to decrypt table data.

Syntax

SELECT DECRYPT(column_name, encryption_key, 'password') FROM SYSTEM.DATABASE.SCHEMA.TABLE

Arguments

  • column_name - column name in following table

  • encryption_key - title of encryption key.

  • ‘password’ - supply password for encryption key if it was set when created.

  • FROM OBJECT - the table containing the column.

Examples

SELECT DECRYPT(card_number, new_key) from sserver.ccard

See Also