In the syscolumns system table, these columns describe encryption properties:
Field |
Type |
Values |
Description |
|---|---|---|---|
encrtype |
int |
null |
Type of data in encrypted form. |
encrlen |
int |
null |
Length of encrypted data. |
encrkeyid |
int |
null |
Object id of key. |
encrkeydb |
varchar (30) |
null |
Database name where the encryption key resides. NULL if key resides in the same database as the encrypted column. |
encrdate |
datetime |
null |
Creation date, copied from sysobjects.crdate. |
