certificates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name sysname 256 null
certificate_id int 4 null
principal_id int 4 √ null
pvt_key_encryption_type char 2 null
pvt_key_encryption_type_desc nvarchar 120 √ null
is_active_for_begin_dialog bit 1 √ null
issuer_name nvarchar 884 √ null
cert_serial_number nvarchar 128 √ null
sid varbinary 85 √ null
string_sid nvarchar 256 √ null
subject nvarchar 8000 √ null
expiry_date datetime 16,3 √ null
start_date datetime 16,3 √ null
thumbprint varbinary 64 null
attested_by nvarchar 520 √ null
pvt_key_last_backup_date datetime 16,3 √ null
key_length int 4 √ null

Relationships