Introduction › Most Frequently Referenced Views › DESCRIPTION View

DESCRIPTION View

The DESCRIPTION view contains the text description for all objects that have descriptions. Using the workstation toolset, you create a row of this Public Interface view when you use the Description option of the Detail command. The DESCRIPTION view has two columns, ID and TEXT as described below:

• ID-Identifier of the object for which this is a description.
• TEXT-Text of the description.

Join ID of DESCRIPTION with ID of the view for which the description was created. If no description exists, none is returned. In the previous table, TEXT is a variable length text field.

For example, to select the name and description of objects in “SQL view,” use this:

SELECT V.NAME, D.TEXT
FROM
MODEL M,
viewname V,
DESCRIPTION D
WHERE
M.NAME='my model name'
AND V.MODE_ID=M.ID
AND D.ID=V.ID;