The result set for sp_help table_name includes
the Decrypt_Default_name column,
which indicates the decrypt default name for the column. For example, if
you run the following:
create table encr_table(col1 int encrypt decrypt_default 1)
When you run sp_help on encr_table, it shows the following:
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
