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)