For tables that include an encrypted column, sp_help tablename displays whether a column is encrypted and whether the encrypted column has a decrypt default. For example:
create table encr_table(col1 int encrypt decrypt_default 1)
The output from this example is similar to:
Column_name Type Length Prec Scale Nulls Default_name Rule_name Access_Rule_name Computed_Column_object Identity Encrypted Decrypt_Default_name ----------- ---- ------ ---- ----- ----- ------------ --------- -------------- -------------------- --------- ------------------------- c1 int 4 NULL NULL 0 NULL NULL NULL NULL 0 1 encr_table_col1_1036527695
