DISPLAY/PUNCH CONSTRAINT

DISPLAY and PUNCH Syntax › DISPLAY/PUNCH CONSTRAINT

DISPLAY/PUNCH CONSTRAINT

The DISPLAY/PUNCH CONSTRAINT statement displays or punches a referential constraint in the dictionary.

Authorization

To issue a DISPLAY/PUNCH CONSTRAINT statement, you must:

Either hold the DISPLAY privilege on or own the referencing table in the constraint
Hold the REFERENCES privilege on the referenced table in the constraint

Syntax

►►─┬─ DISplay ─┬─── CONstraint constraint-name ───────────────────────────────►
   └─ PUNch ───┘

 ►─┬─────────────────────────────┬────────────────────────────────────────────►
   ├─ IN ─┬─ SCHEMA schema-name ─┘
   └─ ON ─┘

 ►─┬──────────────────────────────────────────────────────────────────────┬───►
   └──┬─ WITh ─────────┬──┬─ ALL ───────────────┬─── AS ─┬─ COMments ◄──┬─┘
      ├─ WITHOut ──────┤  ├─ NONe ──────────────┤        └─ SYNtax ─────┘
      ├─ ALSo WITh ────┤  ├─ DETails ───────────┤
      └─ ALSo WITHOut ─┘  └─ HIStory ───────────┘

 ►─┬───────────────────────┬──────────────────────────────────────────────────►◄
   └─ VERb ─┬─ CREate ◄──┬─┘
            ├─ DISplay ──┤
            ├─ DROp ─────┤
            └─ PUNch ────┘

Parameters

constraint-name: Specifies the name of the referential constraint, within the current schema associated with your SQL session (if any), to display or punch.
IN SCHEMA schema-name: Specifies the name of the schema for the referential constraint if no schema is assigned with your SQL session.
WITh: Lists the requested information, in addition to the information that is always included, such as the entity occurrence name.
WITHOut: Does not list the specified options. Other options in effect through the WITH or ALSO WITH clauses in the current DISPLAY statement are displayed.
ALSo WITh: Lists the requested information, in addition to the information requested in previously issued DISPLAY WITH and DISPLAY ALSO WITH statements for the named entity.
ALSo WITHOut: Does not list the specified options.
ALL: Specifies the display of all the information associated with the requested entity occurrence.
NONe: Specifies the display of the name of the requested entity occurrence. NONE is meaningful only when the WITH clause is specified.
DETails: Specifies the display of constraint-specific descriptions.
HIStory: Specifies the display of the date the constraint was created.
AS COMments: Outputs constraint syntax as comments with the characters *+ preceding the text of the statement. AS COMMENTS is the default.
AS SYNtax: Outputs constraint syntax which can be edited and resubmitted to the command facility.
VERB CREate/DISplay/DROp/PUNch: Specifies the verb with which the entity statement is to be displayed or punched. For example, if VERB CREATE is specified, the output of the DISPLAY/PUNCH statement is a CREATE statement; if VERB ALTER is specified, the output is an ALTER statement; and so on. The default is VERB CREATE.