This table contains one row for each query, form, and procedure in the database. The row contains comments entered using the QMF SAVE command when the object was created or last replaced. (See the description of the SAVE command in QMF Reference.)
The Q.OBJECT__REMARKS table has the index Q.OBJECT_REMARKSX, with the attributes UNIQUE and CLUSTER. Keyed columns are OWNER and NAME.
The table has the structure shown in Table 56:
Column name | Data type | Length (bytes) | Nulls allowed? | Function/values |
---|---|---|---|---|
OWNER | CHAR | 8 | No | Shows the authorization ID of the user who created the object |
NAME | VARCHAR | 18 | No | Shows the name of the object. |
TYPE | CHAR | 8 | No | Shows the type of the object: FORM, PROC, or QUERY. |
REMARKS | VARCHAR | 254 | Yes | Contains the comment that was saved with the object when it was created or replaced. |