The X$Field system table is associated with the file FIELD.DDF. X$Field contains
information about all the columns and named indexes defined in the database
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 Scalable SQL assigns. The structure of X$File is as follows:
Column Name Type Size Case Insensitive Description
Xf$Id UNSIGNED 2 N/A Internal ID Scalable SQL assigns.
Xf$Name CHARACTER 20 Yes Table name.
Xf$Loc CHARACTER 64 No File location (pathname).
Xf$Flags UNSIGNED 1 N/A File flags. If bit 4=1, the file is adictionary file.
Xf$Reserved CHARACTER 10 No Reserved.
Two indexes are defined for the X$File table.
