X$File

---

The X$File system table is associated with the file FILE.DDF. For each table defined in the database, X$File contains the table name, the location of the associated table, and a unique internal ID number that Pervasive.SQL assigns. The structure of X$File is as follows:

 
Table C-2 X$File System Table Structure

Column Name	Type	Size	Case Insensitive	Description
Xf$Id	USMALLINT	2	N/A	Internal ID Pervasive.SQL assigns.
Xf$Name	CHAR	20	Yes	Table name.
Xf$Loc	CHAR	64	No	File location (path name).
Xf$Flags	UTINYINT	1	N/A	File flags. If bit 4 = 1, the file is a dictionary file. If bit 4 = 0, the file is user-defined. If bit 6=1, the table supports true nullable columns.
Xf$Reserved	CHAR	10	No	Reserved.

Two indexes are defined for the X$File table.

 
Table C-3 X$File System Table Index Definitions

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