SET ENCRYPTION PASSWORD

The SET ENCRYPTION PASSWORD statement sets the default password and hint that will be used by the encryption and decryption functions. The password is not associated with authentication and is only used for data encryption and decryption.

Example:

The following statement sets the ENCRYPTION PASSWORD:
SET ENCRYPTION PASSWORD 'Gre89Ea'

For more information, see SET ENCRYPTION PASSWORD in the SQL Reference topic in the Information CenterLink to Information center.