SQL

Wednesday, October 29, 2008

System Tables - 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 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.

• Xf$Id
  
• Xf$Name
  

posted by kanun  # 11:55 PM

Archives

September 2008   October 2008   November 2008  

Subscribe to Comments [Atom]