Use the encrypt qualifier to set up encryption on a table column.
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.
Create an employee table with encryption:
create table employee_table (ssn char(15) null encrypt)
create table displays an error if you specify a bigint, unsigned bigint, date, money, text, datetime, or time column for encryption.
create table displays an error if you:
Specify a computed column based on an expression that references one or more encrypted columns.
Use the encrypt and compute parameters on the same column.
create table reports an error if you specify an encrypted column as a partition key.
