Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
RealityV15.1Online Documentation (MoTW) Revision 7
SQLTABLES File (SQL) (m6915ad+sqltables.htm)
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'.
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