Add an encrypted column
- Last Updated: January 16, 2024
- 1 minute read
- OpenEdge
- Version 12.8
- Documentation
You can create a new encrypted LOB column in a table by using either the
CREATE TABLE or the ALTER TABLE ADD COLUMN statements with
the optional ENCRYPT WITH clause. When the ENCRYPT WITH
clause is specified, OpenEdge SQL creates a new encryption object policy for the new
BLOB or CLOB column in the database security schema. The
new column must be either a BLOB or a CLOB data type in a
Type II area to be encrypted. Use the following syntax to create a new encrypted
LOB column:
|