Create Table DDL

ddlgen can generate decrypt_default statements (if set for an encrypted column) along with DDL of a table.

This example issues a ddlgen command on a table called employee which has an “ssn” column that is encrypted with encryption key “ssn_key,” and a decrypt default value that is set to “100”:

ddlgen -Usa -P -Sserver -TU -Nemployee

The DDL output would look like:

create table employee (
  ssn            int       not null  encrypt with ssn_key decrypt_default 100 ,
  last_name      int       not null ,
  first_name     int       not null
)
lock allpages
 on 'default'
go