To encrypt columns in a new table, use the encrypt column qualifier on the create table statement.
create table table_name (column_name . . . [constraint_specification] [encrypt [with [database.[owner].]keyname]] [, next_column_specification . . .] )
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, SAP ASE looks for a default key created using the as default clause on the create encryption key.
create encryption key new_key as default for AES create encryption key cc_key create table employee_table (ssn char(15) encrypt, ename char(50), ...)) create table customer (creditcard char(20) encrypt with cc_key, cc_name char(50), ...)
create encryption key k1 init_vector null pad random create table employee (eid int, esalary money encrypt with k1, ...)