SQL Statements › COMMENT ON › Description

Description

TABLE

Indicates you want to comment on a table or view.

table-name or view-name

Must identify a table or view described in the CA Datacom Datadictionary. The comment is placed in text in CA Datacom Datadictionary.

COLUMN

Indicates you want to comment on a column.

table-name.column-name or view-name.column-name

The name of the column, qualified by the name of the table or view in which it appears. The column must be described in the CA Datacom Datadictionary. The comment is placed in text in CA Datacom Datadictionary.

IS string-literal

The string-literal can be any character string literal enclosed between apostrophes.

column-name IS string-literal

To comment on more than one column in a table or view, do not use TABLE or COLUMN. Give the table or view name and a list of the form:

(column-name IS 'string-literal', column-name IS 'string-literal', column-name IS 'string-literal')

The column comments must be separated by commas and the list must be enclosed with parentheses. All columns named must appear in the same table or view and the table or view must be described in the CA Datacom Datadictionary.