A row of SYSTEM.SYNTAX represents the syntax for a CREATE or ALTER TABLE statement that includes a check constraint, the syntax of a CREATE VIEW statement, or the syntax of an SQL routine. If more than one row is needed to return all the syntax, the order of the syntax portions is represented in column SEQUENCE.
View SYSCA.SYNTAX is defined on SYSTEM.SYNTAX.
Note: For more information, see SYSCA Objects.
|
Column name |
Column description |
Data type |
Null specifi- cation |
|---|---|---|---|
|
SCHEMA |
Schema-name qualifier of the table or view. |
CHAR(18) |
NOT NULL |
|
TABLE |
Table or view name. |
CHAR(18) |
NOT NULL |
|
TYPE |
Syntax usage:
|
CHAR(1) |
NOT NULL |
|
SEQUENCE |
Sequence number of this portion of the syntax. |
SMALLINT |
NOT NULL |
|
SYNTAX |
The check constraint syntax or the syntax of the query expression in the view definition. |
CHAR(80) |
NOT NULL |
|
Copyright © 2014 CA.
All rights reserved.
|
|