X$View

---

The X$View system table is associated with the file VIEW.DDF. X$View contains view definitions, including information about joined tables and the restriction conditions that define views. You can query the X$View table to retrieve the names of the views that are defined in the dictionary.

The first column of the X$View table contains the view name; the second and third columns describe the information found in the LVAR column, Xv$Misc. The structure of X$View is as follows:

 
Table C-11 X$View System Table Structure

Column Name	Type	Size	Case Insensitive	Description
Xv$Name	CHAR	20	Yes	View name.
Xv$Ver	UTINYINT	1	N/A	Version ID.
Xv$Id	UTINYINT	1	N/A	Sequence number.
Xv$Misc	LONGVARCHAR (LVAR)	<=2000	N/A	Pervasive.SQL internal definitions.

Two indexes are defined for the X$View table, as follows:

 
Table C-12 X$View System Table Index Definitions

Index Number	Segment Number	Column Name	Duplicates	Case Insensitive	Segmented
0	0	Xv$Name	Yes	Yes	No
1	0	Xv$Name	No	Yes	Yes
1	1	Xv$Ver	No	N/A	Yes
1	2	Xv$Id	No	N/A	No

Index Number corresponds to the value stored in the Xi$Number column in the X$Index system table. Segment Number corresponds to the value stored in the Xi$Part column in the X$Index system table.