SQLTABLES File

SQLTABLES contains one item for each SQL table that is accessible from the account on which it is defined. These may be of two basic types: table definitions and synonym entries. A table definition may be of two types, identified in attribute one. They are: a normal user table and a system table. The attributes of each item are described below:

Caution

Do not modify the contents of SQLTABLES except by using SQLM.

Note

] = value mark X'FD'.

Table Definition

        ItemId = tablename
001  Table_Type [TABLE or SYSTEM TABLE]
002  Privilege_Grant]Privilege_Grant...
003  Reality_Filename
004  Primary_Key_Column_Name]Primary_Key_Column_Name...
005  Column_Name]Column_Name...
006  Index_Name]Index_Name...
007  Update_Permission
008  Special_Processing_Flag
009  Created_By_SQL
010  Highest_Used_Reality_Attribute_Number
011  Unique_Column_Name]Unique_Column_Name...
012  Foreign_Key_Constraint]Foreign_Key_Constraint...
013  Reference_Column_Name]Reference_Column_Name...
014  Check_Constraints
015  Reserved
016  Remarks