A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iifile_info Catalog
 
Share this page                  
iifile_info Catalog
The iifile_info catalog holds the file name for a table or index. One row is returned for each location on which the table resides.
Column Name
Data Type
Description
table_name
char(256)
The name of the table
owner_name
char(32)
The owner of the table
file_name
char(8)
Name of the file that contains the table
file_ext
char(3)
Extension of the file that contains an extent of the table. The first extent is named t00, succeeding extensions are named t01, t02, and so on.
location
char(32)
The location of the file
base_id
integer
Reltid from iirelation
index_id
integer
Reltidx from iirelation