create table

Use the encrypt qualifier to set up encryption on a table column.

Syntax

create table tablename (colname datatype [default_clause]
                    [encrypt [with [database.[owner].]keyname]])

keyname – identifies a key created using create encryption key. The creator of the table must have select permission on keyname. If keyname is not supplied, Adaptive Server looks for a default key created using the as default clause on create encryption key or alter encryption key.

Example

Create an employee table with encryption:

create table employee_table (ssn char(15) null encrypt)