Each row of the SYSCERTIFICATE system view stores a certificate in text PEM-format. The underlying system table for this view is ISYSCERTIFICATE.
Column name | Data type | Description |
---|---|---|
object_id | UNSIGNED BIGINT | The ID of the certificate. |
cert_name | CHAR(128) | The certificate name. |
contents | LONG BINARY | The certificate contents in a compressed form. |
update_time | TIMESTAMP | The local date and time of the last create or replace. |
update_time_utc | TIMESTAMP WITH TIME ZONE | The UTC date and time of the last create or replace. |
PRIMARY KEY (object_id)
UNIQUE INDEX (cert_name)