home *** CD-ROM | disk | FTP | other *** search
/ Chip 1997 April / Chip_1997-04_cd.bin / prezent / cb / data.z / DBX.DBI < prev    next >
Windows Setup INFormation  |  1997-01-16  |  41KB  |  902 lines
  1.  
  2.  
  3. [Version]
  4. DbXVersion=1.02
  5.  
  6. [Properties]
  7. NET PROTOCOL:Values1=TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  8. NET PROTOCOL:Values2=APPC,ASYNC
  9. OPEN MODE:Values=READ/WRITE,READ ONLY
  10. SHARE MODE:Values=EXCLUSIVE,SHARED
  11. STRICTINTEGRTY:Values=FALSE,TRUE
  12. SQLPASSTHRU MODE:Values=NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  13. LIST SYNONYMS:Values=NONE,ALL,PRIVATE
  14. BLOB EDIT LOGGING:Values=FALSE,TRUE
  15. DEFAULT DRIVER:Values=PARADOX,DBASE
  16. ENABLE SCHEMA CACHE:Values=FALSE,TRUE
  17.  
  18. MSSQL:Identity=select substring(@@version,1,charindex(char(0x0a),@@version)-1)
  19. Sybase:Identity=select @@version
  20. Oracle:Identity=select 'Oracle ' || VERSION_TEXT from SM$VERSION
  21.  
  22. [Repository Properties]
  23. BDETypes:Values1=1="ZString",2="Date",3="Blob",4="Bool",5="Int16",6="Int32"
  24. BDETypes:Values2=7="Float",8="BCD",9="Bytes",10="Time",11="TimeStamp",12="UInt16"
  25. BDETypes:Values3=13="UInt32",14="IEEE Float",15="VarBytes",16="LockInfo"
  26.  
  27. BDESubTypes:Values1=0="",1="Password",21="Money",22="Memo",23="Binary"
  28. BDESubTypes:Values2=24="Formatted Memo",25="OLE Object",26="Graphic"
  29. BDESubTypes:Values3=27="DBase OLE Object",28="Typed Binary",29="Auto Increment"
  30.  
  31. TScale:Values=0=
  32. BooleanTF:Values=0="False",-1="True"
  33. TAlignment:Values=0="taLeftJustify",1="taRightJustify",2="taCenter"
  34.  
  35. TFieldType:Values1=0="ftUnknown",1="ftString",2="ftSmallint",3="ftInteger"
  36. TFieldType:Values2=4="ftWord",5="ftBoolean",6="ftFloat",7="ftCurrency",8="ftBCD"
  37. TFieldType:Values3=9="ftDate",10="ftTime",11="ftDateTime",12="ftBytes"
  38. TFieldType:Values4=13="ftVarBytes",14="ftAutoInc",15="ftBlob",16="ftMemo"
  39. TFieldType:Values5=17="ftGraphic",18="ftFmtMemo",19="ftParadoxOle"
  40. TFieldType:Values6=20="ftDBaseOle",21="ftTypedBinary"
  41.  
  42. TBlobType:Values1=15="ftBlob",16="ftMemo",17="ftGraphic",18="ftFmtMemo"
  43. TBlobType:Values2=19="ftParadoxOle",20="ftDBaseOle",21="ftTypedBinary"
  44.  
  45. DRDATABASES:Reference="Databases"
  46. DREXTFIELDS:Reference="Attribute Sets"
  47. DBTABLES:Reference="Tables"
  48. TABLEFLDS:Reference="Fields"
  49. FLDEXTFIELD:Reference="Attribute Set"
  50. EXTFIELDFLDS:Reference="Referencing Fields"
  51. PARENTEXTFIELD:Reference="Based On"
  52. CHILDEXTFIELD:Reference="Referencing Attribute Sets"
  53.  
  54. DATABASE:Attrs=DBPATH=::-E,DBTYPE=::-E
  55. TABLE:Attrs=PATH=:0,DRIVERTYPE=::-E,ISFILE=:0,ISVIEW=:0,ISSYNONYM=:0
  56. FIELD:Attrs1=PHYTYPE=::-E,LOGTYPE=::-E:VM:BDETypes,LOGSUBTYPE=::-E:VM:BDESubTypes
  57. FIELD:Attrs2=UNITS1=Size::-E,UNITS2=Scale::-E:VM:TScale,DEFVAL=:2:-E,MINVAL=:2:-E
  58. FIELD:Attrs3=MAXVAL=:2:-E,REQUIRED=:2:-E,READONLY=:2:-E
  59. EXTFIELD:Attrs1=ALIGNMENT=:::VM:TAlignment,READONLY=:::VM:BooleanTF
  60. EXTFIELD:Attrs2=REQUIRED=:::VM:BooleanTF,VISIBLE=:::VM:BooleanTF
  61. EXTFIELD:Attrs3=TRANSLITERATE=:::VM:BooleanTF,BLOBTYPE=:::VM:TBlobType
  62.  
  63. [Standard Properties]
  64. DriverType:Values=PARADOX="Paradox",DBASE="dBase"
  65. BooleanYesNo:Values=0="No",-1="Yes"
  66. FieldVChecks:Values=0="",1="Has Validity Checks",2=""
  67. FieldRights:Values=0="Read/Write",1="Read Only",2="None",3=""
  68. PrimaryIndex:Values=="<Primary>"
  69. LookupType:Values1=0="None",1="Current Field",2="All Corresponding"
  70. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  71. ReferenceType:Values=0="Master Of",1="Detail Of"
  72. ReferenceQual:Values=0="Restrict",1="Cascade"
  73. PrivilegeType:Values1=0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  74. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=""
  75. FamilyRightsType:Values=0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  76. FamilyMemberType:Values1=0="Unknown",1="Table",2="Index",3="Form",4="Report"
  77. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  78. FamilyMemberType:Values3=8="Blob File"
  79.  
  80. Standard:Objects=O:"Tables"=Table
  81.  
  82. Table:Attrs1=TYPE="Type"::NR:VM:DriverType,DATE="Date",TIME="Time",VERSION="Version":2
  83. Table:Attrs2=VALID="Valid":2::VM:BooleanYesNo,STRUCTURE="Structure":2
  84. Table:Attrs3=PROTECTED="Protected":2::VM:BooleanYesNo
  85. Table:Name=FILENAME,EXTENSION
  86. Table:Objects1=O:"Fields"=Column,O:"Indices"=Index,O:"Validity Checks"=ValCheck
  87. Table:Objects2=O:"Referential Constraints"=Reference,O:"Security Specs"=Security
  88. Table:Objects3=O:"Family Members"=Family
  89.  
  90. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  91. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  92. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  93.  
  94. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  95. Column:Attrs2=LENGTH="Physical Length"
  96. Column:Name=NAME
  97.  
  98. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  99. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  100. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  101. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  102. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  103. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  104.  
  105. Index:Attrs1=NAME=Name:0::VM:PrimaryIndex,TAGNAME=Tag:0,RESTRNUM="Version":2
  106. Index:Attrs2=PRIMARY="Primary Key":::VM:BooleanYesNo,UNIQUE="Unique"::NR:VM:BooleanYesNo
  107. Index:Attrs3=AUTO="Maintained":2::VM:BooleanYesNo
  108. Index:Attrs4=OUTOFDATE="Out of Date":2::VM:BooleanYesNo
  109. Index:Attrs5=FORMAT="Format":2,BLOCKSIZE="Block Size":2
  110. Index:Attrs6=CASEINSENSITIVE="Case Insensitive":2:NR:VM:BooleanYesNo
  111. Index:Attrs7=DESCENDING="Descending":2:NR:VM:BooleanYesNo
  112. Index:Attrs8=EXPRESSION="Expression":2:N
  113. Index:Attrs9=CONDITION="Subset Condition":2:N
  114. Index:Name=Name,Tag
  115.  
  116. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  117. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  118. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  119. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  120.  
  121. ValCheck:Attrs1=FIELDNUM="Field":2:NR,REQUIRED="Required":1:NR:VM:BooleanYesNo
  122. ValCheck:Attrs2=MINVALUE="Min Value":1:N,MAXVALUE="Max Value":1:N
  123. ValCheck:Attrs3=DEFAULT="Default Value":1:N,PICTURE="Picture":2:N
  124. ValCheck:Name="Field"
  125.  
  126. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  127.  
  128. Family:Attrs=TYPE="Type":1::VM:FamilyMemberType,NAME="Object Name":1
  129. Family:Name=FILENAME
  130.  
  131. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  132. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  133. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  134.  
  135. Reference:Attrs1=TYPE="Reference Type":1::VM:ReferenceType
  136. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  137. Reference:Attrs3=MODOP="Modify Operation":1:NR:VM:ReferenceQual
  138. Reference:Attrs4=DELOP="Delete Operation":1:NR:VM:ReferenceQual
  139. Reference:Name=NAME
  140.  
  141. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  142. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  143.  
  144. Security:Attrs1=TYPE="Table Rights":1:NR:VM:PrivilegeType
  145. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:VS:FamilyRightsType:$0F
  146. Security:Name=PASSWORD
  147.  
  148. [ODBC Properties]
  149. DriverType:Values=PARADOX="Paradox",DBASE="dBase"
  150. BooleanYesNo:Values=0="No",-1="Yes"
  151. FieldVChecks:Values=0="",1="Has Validity Checks",2=""
  152. FieldRights:Values=0="Read/Write",1="Read Only",2="None",3=""
  153. PrimaryIndex:Values=="<Primary>"
  154. LookupType:Values1=0="None",1="Current Field",2="All Corresponding"
  155. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  156. ReferenceType:Values=0="Master Of",1="Detail Of"
  157. ReferenceQual:Values=0="Restrict",1="Cascade"
  158. PrivilegeType:Values1=0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  159. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=""
  160. FamilyRightsType:Values=0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  161.  
  162. ODBC:Objects=O:"Tables"=Table,O:"Stored Procedures"=Procedure
  163.  
  164. Table:Attrs1=TYPE="Type"::NR:VM:DriverType,DATE="Date",TIME="Time",VERSION="Version":2
  165. Table:Attrs2=VALID="Valid":2::VM:BooleanYesNo,STRUCTURE="Structure":2
  166. Table:Attrs3=PROTECTED="Protected":2::VM:BooleanYesNo
  167. Table:Name=FILENAME,EXTENSION
  168. Table:Objects1=O:"Fields"=Column,O:"Indices"=Index,O:"Validity Checks"=ValCheck
  169. Table:Objects2=O:"Referential Constraints"=Reference,O:"Security Specs"=Security
  170.  
  171. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  172. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  173. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  174.  
  175. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  176. Column:Attrs2=LENGTH="Physical Length"
  177. Column:Name=NAME
  178.  
  179. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  180. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  181. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  182. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  183. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  184. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  185.  
  186. Index:Attrs1=NAME=Name:0::VM:PrimaryIndex,TAGNAME=Tag:0,RESTRNUM="Version":2
  187. Index:Attrs2=PRIMARY="Primary Key":::VM:BooleanYesNo,UNIQUE="Unique"::NR:VM:BooleanYesNo
  188. Index:Attrs3=AUTO="Maintained":2::VM:BooleanYesNo
  189. Index:Attrs4=OUTOFDATE="Out of Date":2::VM:BooleanYesNo
  190. Index:Attrs5=FORMAT="Format":2,BLOCKSIZE="Block Size":2
  191. Index:Attrs6=CASEINSENSITIVE="Case Insensitive":2:NR:VM:BooleanYesNo
  192. Index:Attrs7=DESCENDING="Descending":2:NR:VM:BooleanYesNo
  193. Index:Attrs8=EXPRESSION="Expression":2:N
  194. Index:Attrs9=CONDITION="Subset Condition":2:N
  195. Index:Name=Name,Tag
  196.  
  197. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  198. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  199. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  200. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  201.  
  202. ValCheck:Attrs1=FIELDNUM="Field":2:NR,REQUIRED="Required":1:NR:VM:BooleanYesNo
  203. ValCheck:Attrs2=MINVALUE="Min Value":1:N,MAXVALUE="Max Value":1:N
  204. ValCheck:Attrs3=DEFAULT="Default Value":1:N,PICTURE="Picture":2:N
  205. ValCheck:Name="Field"
  206.  
  207. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  208. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  209. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  210.  
  211. Reference:Attrs1=TYPE="Reference Type":1::VM:ReferenceType
  212. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  213. Reference:Attrs3=MODOP="Modify Operation":1:NR:VM:ReferenceQual
  214. Reference:Attrs4=DELOP="Delete Operation":1:NR:VM:ReferenceQual
  215. Reference:Name=NAME
  216.  
  217. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  218. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  219.  
  220. Security:Attrs1=TYPE="Table Rights":1:NR:VM:PrivilegeType
  221. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:VS:FamilyRightsType:$0F
  222. Security:Name=PASSWORD
  223.  
  224. Procedure:Name=NAME
  225.  
  226. [Oracle Properties]
  227. BooleanNY:Values=N="No",Y="Yes"
  228. Unique:Values=NONUNIQUE="No",UNIQUE="Yes"
  229.  
  230. Oracle:Objects1=O:"Tables"=Table,O:"Views"=View,O:"Synonyms"=Synonym
  231. Oracle:Objects2=O:"Snapshots"=Snapshot,O:"Packages"=Unit,O:"Procedures"=Procedure
  232. Oracle:Objects3=O:"Functions"=Function,O:"Sequences"=Generator
  233.  
  234. Table:Root=SYS.ALL_TABLES
  235. View:Root=SYS.ALL_OBJECTS
  236. Synonym:Root=SYS.ALL_SYNONYMS
  237. Snapshot:Root=SYS.ALL_SNAPSHOTS
  238. Unit:Root=SYS.ALL_OBJECTS
  239. UnitBody:Root=SYS.ALL_OBJECTS
  240. Function:Root=SYS.ALL_OBJECTS
  241. Procedure:Root=SYS.ALL_OBJECTS
  242. Generator:Root=SYS.ALL_SEQUENCES
  243. Index:Root=SYS.ALL_INDEXES
  244. IndexColumn:Root=SYS.ALL_IND_COLUMNS
  245. Column:Root=SYS.ALL_TAB_COLUMNS
  246. FormalParameter:Root=SYS.ALL_TAB_COLUMNS
  247. Trigger:Root=SYS.ALL_TRIGGERS
  248. PrimaryKey:Root=SYS.ALL_CONSTRAINTS
  249. ForeignKey:Root=SYS.ALL_CONSTRAINTS
  250. CheckConstraint:Root=SYS.ALL_CONSTRAINTS
  251. UniqueConstraint:Root=SYS.ALL_CONSTRAINTS
  252. ConstraintColumn:Root=SYS.ALL_CONS_COLUMNS
  253.  
  254. SYS.ALL_OBJECTS:Attrs=CREATED="Created",LAST_DDL_TIME="Modified"
  255. SYS.ALL_OBJECTS:Name=OWNER,OBJECT_NAME
  256. SYS.ALL_OBJECTS:FilterSystemObjects=A.OWNER <> 'SYS'
  257.  
  258. SYS.ALL_TABLES:Objects1=T:"Primary Key"=PrimaryKey,T:"Indices"=Index
  259. SYS.ALL_TABLES:Objects2=T:"Columns"=Column
  260. SYS.ALL_TABLES:Objects3=T:"Referential Constraints"=ForeignKey
  261. SYS.ALL_TABLES:Objects4=T:"Unique Constraints"=UniqueConstraint
  262. SYS.ALL_TABLES:Objects5=T:"Check Constraints"=CheckConstraint
  263. SYS.ALL_TABLES:Objects6=T:"Triggers"=Trigger
  264. SYS.ALL_TABLES:Attrs1=NUM_ROWS="Row Count",BACKED_UP="Backed Up":::VM:BooleanNY
  265. SYS.ALL_TABLES:Attrs2=TABLESPACE_NAME="TableSpace",CLUSTER_NAME="Cluster"
  266. SYS.ALL_TABLES:Attrs3=INI_TRANS="Initial Transactions":2
  267. SYS.ALL_TABLES:Attrs4=MAX_TRANS="Maximum Transactions":2,CHAIN_CNT="Chained Rows":2
  268. SYS.ALL_TABLES:Attrs5=BLOCKS="Data Block Count":2,EMPTY_BLOCKS="Empty Data Blocks":2
  269. SYS.ALL_TABLES:Attrs6=AVG_SPACE="Avg Bytes Free / Block":2,AVG_ROW_LEN="Avg Row Length":2
  270. SYS.ALL_TABLES:Attrs7=PCT_FREE="Block Min % Free":2,PCT_USED="Block Min % Used":2
  271. SYS.ALL_TABLES:Attrs8=INITIAL_EXTENT="Initial Extent Bytes":2
  272. SYS.ALL_TABLES:Attrs9=MAX_EXTENTS="Max Extents":2,PCT_INCREASE="Extent Size % Increase"
  273. SYS.ALL_TABLES:Name=OWNER,TABLE_NAME
  274. SYS.ALL_TABLES:Reference:"Columns"=OWNER=OWNER,TABLE_NAME=TABLE_NAME
  275. SYS.ALL_TABLES:Reference:"Indices"=OWNER=TABLE_OWNER,TABLE_NAME=TABLE_NAME
  276. SYS.ALL_TABLES:Reference:"Primary Key"=OWNER=OWNER,TABLE_NAME=TABLE_NAME
  277. SYS.ALL_TABLES:Reference:"Referential Constraints"=OWNER=OWNER,TABLE_NAME=TABLE_NAME
  278. SYS.ALL_TABLES:Reference:"Unique Constraints"=OWNER=OWNER,TABLE_NAME=TABLE_NAME
  279. SYS.ALL_TABLES:Reference:"Check Constraints"=OWNER=OWNER,TABLE_NAME=TABLE_NAME
  280. SYS.ALL_TABLES:Reference:"Triggers"=OWNER=TABLE_OWNER,TABLE_NAME=TABLE_NAME
  281. SYS.ALL_TABLES:FilterSystemObjects=A.OWNER <> 'SYS'
  282.  
  283. SYS.ALL_SYNONYMS:Attrs1=TABLE_OWNER="Target Owner",TABLE_NAME="Target Object"
  284. SYS.ALL_SYNONYMS:Attrs2=DB_LINK="Database"
  285. SYS.ALL_SYNONYMS:Name=OWNER,SYNONYM_NAME
  286.  
  287. SYS.ALL_SNAPSHOTS:Objects=T:"Table"=Table
  288. SYS.ALL_SNAPSHOTS:Attrs1=TABLE_NAME="Table",LAST_REFRESH="Last Refresh",ERROR="Error"
  289. SYS.ALL_SNAPSHOTS:Attrs2=TYPE="Refresh Type":2,NEXT="Next Refresh":2
  290. SYS.ALL_SNAPSHOTS:Attrs3=START_WITH="First Refresh":2,MASTER_OWNER="Master Owner":2
  291. SYS.ALL_SNAPSHOTS:Attrs4=MASTER_VIEW="Master View":2,MASTER="Master Table":2
  292. SYS.ALL_SNAPSHOTS:Attrs5=MASTER_LINK="Master Database":2,CAN_USE_LOG="Snapshot Log":2
  293. SYS.ALL_SNAPSHOTS:Attrs6=QUERY="Snapshot Query":2
  294. SYS.ALL_SNAPSHOTS:Name=OWNER,NAME
  295. SYS.ALL_SNAPSHOTS:Reference:"Table"=OWNER=OWNER,TABLE_NAME=TABLE_NAME
  296.  
  297. SYS.ALL_INDEXES:Objects=T:"Columns"=IndexColumn
  298. SYS.ALL_INDEXES:Attrs1=UNIQUENESS="Unique":::VM:Unique,TABLESPACE_NAME="Tablespace":2
  299. SYS.ALL_INDEXES:Attrs2=INITIAL_EXTENT="Initial Extent Size":2
  300. SYS.ALL_INDEXES:Attrs3=NEXT_EXTENT="Other Extents Size":2
  301. SYS.ALL_INDEXES:Attrs4=MIN_EXTENTS="Minimum Extents":2,MAX_EXTENTS="Maximum Extents":2
  302. SYS.ALL_INDEXES:Attrs5=PCT_INCREASE="Percent Increase":2,PCT_FREE="Minimum Percent Free":2
  303. SYS.ALL_INDEXES:Attrs6=INI_TRANS="Initial Transactions":2,MAX_TRANS="Maximum Transactions":2
  304. SYS.ALL_INDEXES:Name=OWNER,INDEX_NAME
  305.  
  306. SYS.ALL_INDEXES:Reference:"Columns"1=OWNER=INDEX_OWNER,INDEX_NAME=INDEX_NAME
  307. SYS.ALL_INDEXES:Reference:"Columns"2=TABLE_OWNER=TABLE_OWNER,TABLE_NAME=TABLE_NAME
  308.  
  309. SYS.ALL_IND_COLUMNS:Keys=COLUMN_POSITION
  310. SYS.ALL_IND_COLUMNS:Name=COLUMN_NAME
  311.  
  312. SYS.ALL_TAB_COLUMNS:Keys=COLUMN_ID
  313. SYS.ALL_TAB_COLUMNS:Attrs1=DATA_TYPE="Type",DATA_LENGTH="Length"
  314. SYS.ALL_TAB_COLUMNS:Attrs2=DATA_PRECISION="Precision",DATA_SCALE="Scale"
  315. SYS.ALL_TAB_COLUMNS:Attrs3=NULLABLE="Nulls":::VM:BooleanNY
  316. SYS.ALL_TAB_COLUMNS:Name=COLUMN_NAME
  317.  
  318. SYS.ALL_SEQUENCES:Attrs1=LAST_NUMBER="Last Value",INCREMENT_BY="Increment By"
  319. SYS.ALL_SEQUENCES:Attrs2=CYCLE_FLAG="Cycle":::VM:BooleanNY
  320. SYS.ALL_SEQUENCES:Attrs3=ORDER_FLAG="In Order":::VM:BooleanNY
  321. SYS.ALL_SEQUENCES:Attrs4=MIN_VALUE="Minimum Value":2,MAX_VALUE="Maximum Value":2
  322. SYS.ALL_SEQUENCES:Attrs5=CACHE_SIZE="Cache Size":2
  323. SYS.ALL_SEQUENCES:Name=SEQUENCE_OWNER,SEQUENCE_NAME
  324.  
  325. SYS.ALL_TRIGGERS:Objects=T:"Table"=Table
  326. SYS.ALL_TRIGGERS:Attrs1=TRIGGERING_EVENT="Event",TRIGGER_TYPE="Type"
  327. SYS.ALL_TRIGGERS:Attrs2=REFERENCING_NAMES="Referencing Names":2
  328. SYS.ALL_TRIGGERS:Attrs3=WHEN_CLAUSE="When":2,DESCRIPTION="Description":2
  329. SYS.ALL_TRIGGERS:Attrs4=TRIGGER_BODY="Text":3
  330. SYS.ALL_TRIGGERS:Name=OWNER,TRIGGER_NAME
  331. SYS.ALL_TRIGGERS:Reference:"Table"=TABLE_OWNER=OWNER,TABLE_NAME=TABLE_NAME
  332.  
  333. SYS.ALL_CONSTRAINTS:Objects=T:"Table"=Table,T:"Columns"=ConstraintColumn
  334. SYS.ALL_CONSTRAINTS:Attrs=STATUS="Status":2
  335. SYS.ALL_CONSTRAINTS:Name=CONSTRAINT_NAME
  336. SYS.ALL_CONSTRAINTS:Reference:"Table"=OWNER=OWNER,TABLE_NAME=TABLE_NAME
  337. SYS.ALL_CONSTRAINTS:Reference:"Columns"1=OWNER=OWNER
  338. SYS.ALL_CONSTRAINTS:Reference:"Columns"2=CONSTRAINT_NAME=CONSTRAINT_NAME
  339. SYS.ALL_CONSTRAINTS:Reference:"Columns"3=TABLE_NAME=TABLE_NAME
  340.  
  341. SYS.ALL_CONS_COLUMNS:Keys=POSITION
  342. SYS.ALL_CONS_COLUMNS:Name=COLUMN_NAME
  343.  
  344. PrimaryKey:Values=CONSTRAINT_TYPE:=P
  345.  
  346. ForeignKey:Values=CONSTRAINT_TYPE:=R
  347. ForeignKey:Attrs=DELETE_RULE="Delete Rule":2
  348.  
  349. UniqueConstraint:Values=CONSTRAINT_TYPE:=U
  350.  
  351. CheckConstraint:Values=CONSTRAINT_TYPE:=C
  352. CheckConstraint:Attrs=SEARCH_CONDITION="Text":3
  353.  
  354. Generator:Attrs:Q="Created":2,"Modified":2
  355. Generator:AttrReference:"Created"1=select CREATED from SYS.ALL_OBJECTS where
  356. Generator:AttrReference:"Created"2=OWNER=%CSEQUENCE_OWNER% and OBJECT_NAME=%CSEQUENCE_NAME%
  357. Generator:AttrReference:"Modified"1=select CREATED from SYS.ALL_OBJECTS where
  358. Generator:AttrReference:"Modified"2=OWNER=%CSEQUENCE_OWNER% and OBJECT_NAME=%CSEQUENCE_NAME%
  359.  
  360. ; X:Actions=Data,New,Delete,Modify,Rename,Save
  361.  
  362. Table:Attrs:Q="Created":2,"Modified":2
  363. Table:AttrReference:"Created"1=select CREATED from SYS.ALL_OBJECTS where
  364. Table:AttrReference:"Created"2=OWNER=%COWNER% and OBJECT_NAME=%CTABLE_NAME%
  365. Table:AttrReference:"Modified"1=select CREATED from SYS.ALL_OBJECTS where
  366. Table:AttrReference:"Modified"2=OWNER=%COWNER% and OBJECT_NAME=%CTABLE_NAME%
  367. Table:Actions=Data
  368. Table:Actions:Delete=DROP TABLE %N%
  369.  
  370. View:Values=OBJECT_TYPE:=VIEW
  371. View:Objects=T:"Columns"=Column
  372. View:Actions=Data
  373. View:Reference:"Columns"=OWNER=OWNER,OBJECT_NAME=TABLE_NAME
  374. View:Attrs:Q="Text"
  375. View:AttrReference:"Text"1=select TEXT from SYS.ALL_VIEWS
  376. View:AttrReference:"Text"2=where OWNER=%COWNER% and VIEW_NAME=%COBJECT_NAME%
  377. View:Actions:Delete=DROP VIEW %N%
  378.  
  379. Synonym:Attrs:Q="Created":2,"Modified":2
  380. Synonym:AttrReference:"Created"1=select CREATED from SYS.ALL_OBJECTS where
  381. Synonym:AttrReference:"Created"2=OWNER=%COWNER% and OBJECT_NAME=%CSYNONYM_NAME%
  382. Synonym:AttrReference:"Modified"1=select CREATED from SYS.ALL_OBJECTS where
  383. Synonym:AttrReference:"Modified"2=OWNER=%COWNER% and OBJECT_NAME=%CSYNONYM_NAME%
  384. Synonym:Actions=Data
  385.  
  386. Procedure:Values=OBJECT_TYPE:=PROCEDURE
  387. Procedure:Objects=T:"Parameters"=FormalParameter
  388. Procedure:Actions=
  389. Procedure:Reference:"Parameters"=OWNER=OWNER,OBJECT_NAME=TABLE_NAME
  390. Procedure:Attrs:Q="Text"
  391. Procedure:AttrReference:"Text"1=select TEXT from SYS.ALL_SOURCE
  392. Procedure:AttrReference:"Text"2=where OWNER=%COWNER% and NAME=%COBJECT_NAME%
  393. Procedure:AttrReference:"Text"3=order by LINE
  394.  
  395. Function:Values=OBJECT_TYPE:=FUNCTION
  396. Function:Objects=T:"Parameters"=FormalParameter
  397. Function:Actions=
  398. Function:Reference:"Parameters"=OWNER=OWNER,OBJECT_NAME=TABLE_NAME
  399. Function:Attrs:Q="Text"
  400. Function:AttrReference:"Text"1=select TEXT from SYS.ALL_SOURCE
  401. Function:AttrReference:"Text"2=where OWNER=%COWNER% and NAME=%COBJECT_NAME%
  402. Function:AttrReference:"Text"3=order by LINE
  403.  
  404. Unit:Values=OBJECT_TYPE:=PACKAGE
  405. Unit:Objects=T:"Package Body"=UnitBody
  406. Unit:Actions=
  407. Unit:Reference:"Package Body"=OWNER=OWNER,OBJECT_NAME=OBJECT_NAME
  408. Unit:Attrs:Q="Text"
  409. Unit:AttrReference:"Text"1=select TEXT from SYS.ALL_SOURCE
  410. Unit:AttrReference:"Text"2=where OWNER=%COWNER% and NAME=%COBJECT_NAME%
  411. Unit:AttrReference:"Text"3=and TYPE=%COBJECT_TYPE% order by LINE
  412.  
  413. UnitBody:Values=OBJECT_TYPE:=PACKAGE BODY
  414. UnitBody:Actions=
  415. UnitBody:Attrs:Q="Text"
  416. UnitBody:AttrReference:"Text"1=select TEXT from SYS.ALL_SOURCE
  417. UnitBody:AttrReference:"Text"2=where OWNER=%COWNER% and NAME=%COBJECT_NAME%
  418. UnitBody:AttrReference:"Text"3=and TYPE=%COBJECT_TYPE% order by LINE
  419.  
  420. [MSSQL Properties]
  421. BooleanYesNo:Values=0="No",-1="Yes"
  422. ObjectType:Values1=S="System Table",U="Table",V="View",L="Log",P="Procedure",
  423. ObjectType:Values2=R="Rule",D="Default",TR="Trigger",RI="Referential Constraint"
  424. ObjectStatus:Values=256="Read Only",4096="RamboIX"
  425. ColumnStatus:Values=8="NULL"
  426. IndexStatus:Values1=1="Dup Key Abort",2="Unique",4="Dup Row Abort",16="Clustered"
  427. IndexStatus:Values2=64="Allow Dup Rows",32768="Suspect"
  428.  
  429. MSSQL:Objects1=O:"Data Types"=DataType,O:"Tables"=Table,O:"Views"=View
  430. MSSQL:Objects2=O:"Stored Procedures"=Procedure,O:"Defaults"=Default
  431. MSSQL:Objects3=O:"Triggers"=Trigger,O:"Rules"=CheckConstraint,O:"Users"=User
  432.  
  433. Table:Root=dbo.sysobjects
  434. View:Root=dbo.sysobjects
  435. Procedure:Root=dbo.sysobjects
  436. Default:Root=dbo.sysobjects
  437. CheckConstraint:Root=dbo.sysobjects
  438. Trigger:Root=dbo.sysobjects
  439. DataType:Root=dbo.systypes
  440. Index:Root=dbo.sysindexes
  441. Column:Root=dbo.syscolumns
  442. FormalParameter:Root=dbo.syscolumns
  443. User:Root=dbo.sysusers
  444.  
  445. dbo.sysobjects:Attrs1=type="Type":::VM:ObjectType,crdate="Creation Date"
  446. dbo.sysobjects:Attrs2=sysstat="Status":::VS:ObjectStatus:$1100
  447. dbo.sysobjects:Name="Owner",name
  448. dbo.sysobjects:FilterSystemObjects=user_name(A.uid) <> 'dbo'
  449.  
  450. dbo.syscolumns:Keys=id,colid
  451. dbo.syscolumns:Objects=T:"Data Type"=DataType
  452. dbo.syscolumns:Reference:"Data Type"=usertype=usertype
  453. dbo.syscolumns:Attrs1=colid="Column Id",length="Length"
  454. dbo.syscolumns:Attrs2=status="Status":::VS:ColumnStatus:$8
  455. dbo.syscolumns:Name=name
  456.  
  457. dbo.sysindexes:Objects=Q:"Columns"=IndexColumn
  458. dbo.sysindexes:Attrs1=status="Status":::VS:IndexStatus:$FF7F,indid="Index Id":2
  459. dbo.sysindexes:Attrs2=rowpage="Rows per page":2,minlen="Minimum row size":2
  460. dbo.sysindexes:Attrs3=maxlen="Maximum row size":2
  461. dbo.sysindexes:Name=name
  462.  
  463. dbo.systypes:Attrs1=length="Length"
  464. dbo.systypes:Attrs2=variable="Variable Length":::VM:BooleanYesNo
  465. dbo.systypes:Attrs3=allownulls="Nulls Allowed":::VM:BooleanYesNo
  466. dbo.systypes:Objects=T:"Default Value"=Default,T:"Domain Rule"=CheckConstraint
  467. dbo.systypes:Name="Owner",name
  468. dbo.systypes:Reference:"Default Value"=tdefault=id
  469. dbo.systypes:Reference:"Domain Rule"=domain=id
  470.  
  471. dbo.sysusers:Name=name
  472.  
  473. Table:Values=type:=U;=S
  474. Table:FilterSystemObjects=A.type <> 'S'
  475. Table:Objects1=T:"Insert Trigger"=Trigger,T:"Delete Trigger"=Trigger
  476. Table:Objects2=T:"Update Trigger"=Trigger,T:"Indices"=Index,T:"Columns"=Column
  477. Table:Actions=Data
  478. Table:Reference:"Insert Trigger"=instrig=id
  479. Table:Reference:"Delete Trigger"=deltrig=id
  480. Table:Reference:"Update Trigger"=updtrig=id
  481. Table:Reference:"Columns"=id=id
  482. Table:Reference:"Indices"=id=id
  483. Table:Attrs:T=dbo.sysusers.name="Owner":name:0
  484. Table:AttrReference:"Owner"=uid=uid
  485. Table:Actions:Delete=DROP TABLE %N%
  486.  
  487. View:Values=type:=V
  488. View:Objects1=T:"Insert Trigger"=Trigger,T:"Delete Trigger"=Trigger
  489. View:Objects2=T:"Update Trigger"=Trigger,T:"Columns"=Column
  490. View:Actions=Data
  491. View:Reference:"Insert Trigger"=instrig=id
  492. View:Reference:"Delete Trigger"=deltrig=id
  493. View:Reference:"Update Trigger"=updtrig=id
  494. View:Reference:"Columns"=id=id
  495. View:Attrs:T=dbo.sysusers.name="Owner":name:0
  496. View:Attrs:Q="Text"
  497. View:AttrReference:"Owner"=uid=uid
  498. View:AttrReference:"Text"1=select text from dbo.syscomments
  499. View:AttrReference:"Text"2=where id=%Cid% order by colid
  500. View:Actions:Delete=DROP VIEW %N%
  501.  
  502. Procedure:Values=type:=P
  503. Procedure:Objects=T:"Parameters"=FormalParameter
  504. Procedure:Actions=
  505. Procedure:Reference:"Parameters"=id=id
  506. Procedure:Attrs:T=dbo.sysusers.name="Owner":name:0
  507. Procedure:Attrs:Q="Text"
  508. Procedure:AttrReference:"Owner"=uid=uid
  509. Procedure:AttrReference:"Text"1=select text from dbo.syscomments
  510. Procedure:AttrReference:"Text"2=where id=%Cid% order by colid
  511.  
  512. Default:Values=type:=D
  513. Default:Actions=
  514. Default:Attrs:T=dbo.sysusers.name="Owner":name:0
  515. Default:Attrs:Q="Text"
  516. Default:AttrReference:"Owner"=uid=uid
  517. Default:AttrReference:"Text"1=select text from dbo.syscomments
  518. Default:AttrReference:"Text"2=where id=%Cid% order by colid
  519.  
  520. CheckConstraint:Values=type:=R
  521. CheckConstraint:Actions=
  522. CheckConstraint:Attrs:T=dbo.sysusers.name="Owner":name:0
  523. CheckConstraint:Attrs:Q="Text"
  524. CheckConstraint:AttrReference:"Owner"=uid=uid
  525. CheckConstraint:AttrReference:"Text"1=select text from dbo.syscomments
  526. CheckConstraint:AttrReference:"Text"2=where id=%Cid% order by colid
  527.  
  528. Trigger:Values=type:=TR
  529. Trigger:Actions=
  530. Trigger:Attrs:T=dbo.sysusers.name="Owner":name:0
  531. Trigger:Attrs:Q="Text"
  532. Trigger:AttrReference:"Owner"=uid=uid
  533. Trigger:AttrReference:"Text"1=select text from dbo.syscomments
  534. Trigger:AttrReference:"Text"2=where id=%Cid% order by colid
  535.  
  536. RIConstraint:Attrs:T=dbo.sysusers.name="Owner":name:0
  537. RIConstraint:AttrReference:"Owner"=uid=uid
  538.  
  539. Column:Attrs:T=dbo.systypes.name="Data Type":"Length"
  540. Column:AttrReference:"Data Type"=usertype=usertype
  541.  
  542. IndexColumn:Query1=select Id=c.colid, Name=INDEX_COL('%PN%', x.indid, c.colid)
  543. IndexColumn:Query2=from sysindexes x, syscolumns c
  544. IndexColumn:Query3=where (x.id = %Cid%) and (x.id = c.id) and
  545. IndexColumn:Query4=(x.name = '%N%') and (c.colid <= keycnt) and
  546. IndexColumn:Query5=(INDEX_COL('%PN%', x.indid, c.colid) != '')
  547. IndexColumn:Keys=Id
  548. IndexColumn:Attrs=Name=:0,Id=:0
  549. IndexColumn:Name=Name
  550.  
  551. Index:Values=keycnt:>0
  552.  
  553. FormalParameter:Attrs:T=dbo.systypes.name="Data Type":"Length"
  554. FormalParameter:AttrReference:"Data Type"=usertype=usertype
  555.  
  556. DataType:Actions=
  557. DataType:Attrs:T=dbo.sysusers.name="Owner":name:0
  558. DataType:AttrReference:"Owner"=uid=uid
  559.  
  560. User:Values=uid:<16384
  561.  
  562. [Sybase Properties]
  563. BooleanYesNo:Values=0="No",-1="Yes"
  564. ObjectType:Values1=S="System Table",U="Table",V="View",L="Log",P="Procedure",
  565. ObjectType:Values2=R="Rule",D="Default",TR="Trigger",RI="Referential Constraint"
  566. ObjectStatus:Values=256="Read Only",4096="RamboIX"
  567. ColumnStatus:Values=8="NULL"
  568. IndexStatus:Values1=1="Dup Key Abort",2="Unique",4="Dup Row Abort",16="Clustered"
  569. IndexStatus:Values2=64="Allow Dup Rows",32768="Suspect"
  570.  
  571. Sybase:Objects1=O:"Data Types"=DataType,O:"Tables"=Table,O:"Views"=View
  572. Sybase:Objects2=O:"Stored Procedures"=Procedure,O:"Defaults"=Default
  573. Sybase:Objects3=O:"Triggers"=Trigger,O:"Rules"=CheckConstraint,O:"Users"=User
  574.  
  575. Table:Root=dbo.sysobjects
  576. View:Root=dbo.sysobjects
  577. Procedure:Root=dbo.sysobjects
  578. Default:Root=dbo.sysobjects
  579. CheckConstraint:Root=dbo.sysobjects
  580. Trigger:Root=dbo.sysobjects
  581. DataType:Root=dbo.systypes
  582. Index:Root=dbo.sysindexes
  583. Column:Root=dbo.syscolumns
  584. FormalParameter:Root=dbo.syscolumns
  585. User:Root=dbo.sysusers
  586.  
  587. dbo.sysobjects:Attrs1=type="Type":::VM:ObjectType,crdate="Creation Date"
  588. dbo.sysobjects:Attrs2=sysstat="Status":::VS:ObjectStatus:$1100
  589. dbo.sysobjects:Name="Owner",name
  590. dbo.sysobjects:FilterSystemObjects=user_name(A.uid) <> 'dbo'
  591. dbo.sysobjects:Dataset1=name,id,uid,type,userstat,sysstat,indexdel,
  592. dbo.sysobjects:Dataset2=crdate,expdate,deltrig,instrig,updtrig,seltrig
  593.  
  594. dbo.syscolumns:Keys=id,colid
  595. dbo.syscolumns:Objects=T:"Data Type"=DataType
  596. dbo.syscolumns:Reference:"Data Type"=usertype=usertype
  597. dbo.syscolumns:Attrs1=colid="Column Id",length="Length"
  598. dbo.syscolumns:Attrs2=status="Status":::VS:ColumnStatus:$8
  599. dbo.syscolumns:Name=name
  600.  
  601. dbo.sysindexes:Objects=Q:"Columns"=IndexColumn
  602. dbo.sysindexes:Attrs1=status="Status":::VS:IndexStatus:$FF7F,indid="Index Id":2
  603. dbo.sysindexes:Attrs2=minlen="Minimum row size":2
  604. dbo.sysindexes:Attrs3=maxlen="Maximum row size":2
  605. dbo.sysindexes:Name=name
  606.  
  607. dbo.systypes:Attrs1=length="Length"
  608. dbo.systypes:Attrs2=variable="Variable Length":::VM:BooleanYesNo
  609. dbo.systypes:Attrs3=allownulls="Nulls Allowed":::VM:BooleanYesNo
  610. dbo.systypes:Objects=T:"Default Value"=Default,T:"Domain Rule"=CheckConstraint
  611. dbo.systypes:Name="Owner",name
  612. dbo.systypes:Reference:"Default Value"=tdefault=id
  613. dbo.systypes:Reference:"Domain Rule"=domain=id
  614.  
  615. dbo.sysusers:Name=name
  616.  
  617. Table:Values=type:=U;=S
  618. Table:FilterSystemObjects=A.type <> 'S'
  619. Table:Objects1=T:"Insert Trigger"=Trigger,T:"Delete Trigger"=Trigger
  620. Table:Objects2=T:"Update Trigger"=Trigger,T:"Indices"=Index,T:"Columns"=Column
  621. Table:Actions=Data
  622. Table:Reference:"Insert Trigger"=instrig=id
  623. Table:Reference:"Delete Trigger"=deltrig=id
  624. Table:Reference:"Update Trigger"=updtrig=id
  625. Table:Reference:"Columns"=id=id
  626. Table:Reference:"Indices"=id=id
  627. Table:Attrs:T=dbo.sysusers.name="Owner":name:0
  628. Table:AttrReference:"Owner"=uid=uid
  629. Table:Actions:Delete=DROP TABLE %N%
  630.  
  631. View:Values=type:=V
  632. View:Objects1=T:"Insert Trigger"=Trigger,T:"Delete Trigger"=Trigger
  633. View:Objects2=T:"Update Trigger"=Trigger,T:"Columns"=Column
  634. View:Actions=Data
  635. View:Reference:"Insert Trigger"=instrig=id
  636. View:Reference:"Delete Trigger"=deltrig=id
  637. View:Reference:"Update Trigger"=updtrig=id
  638. View:Reference:"Columns"=id=id
  639. View:Attrs:T=dbo.sysusers.name="Owner":name:0
  640. View:Attrs:Q="Text"
  641. View:AttrReference:"Owner"=uid=uid
  642. View:AttrReference:"Text"1=select text from dbo.syscomments
  643. View:AttrReference:"Text"2=where id=%Cid% order by colid
  644. View:Actions:Delete=DROP VIEW %N%
  645.  
  646. Procedure:Values=type:=P
  647. Procedure:Objects=T:"Parameters"=FormalParameter
  648. Procedure:Actions=
  649. Procedure:Reference:"Parameters"=id=id
  650. Procedure:Attrs:T=dbo.sysusers.name="Owner":name:0
  651. Procedure:Attrs:Q="Text"
  652. Procedure:AttrReference:"Owner"=uid=uid
  653. Procedure:AttrReference:"Text"1=select text from dbo.syscomments
  654. Procedure:AttrReference:"Text"2=where id=%Cid% order by colid
  655.  
  656. Default:Values=type:=D
  657. Default:Actions=
  658. Default:Attrs:T=dbo.sysusers.name="Owner":name:0
  659. Default:Attrs:Q="Text"
  660. Default:AttrReference:"Owner"=uid=uid
  661. Default:AttrReference:"Text"1=select text from dbo.syscomments
  662. Default:AttrReference:"Text"2=where id=%Cid% order by colid
  663.  
  664. CheckConstraint:Values=type:=R
  665. CheckConstraint:Actions=
  666. CheckConstraint:Attrs:T=dbo.sysusers.name="Owner":name:0
  667. CheckConstraint:Attrs:Q="Text"
  668. CheckConstraint:AttrReference:"Owner"=uid=uid
  669. CheckConstraint:AttrReference:"Text"1=select text from dbo.syscomments
  670. CheckConstraint:AttrReference:"Text"2=where id=%Cid% order by colid
  671.  
  672. Trigger:Values=type:=TR
  673. Trigger:Actions=
  674. Trigger:Attrs:T=dbo.sysusers.name="Owner":name:0
  675. Trigger:Attrs:Q="Text"
  676. Trigger:AttrReference:"Owner"=uid=uid
  677. Trigger:AttrReference:"Text"1=select text from dbo.syscomments
  678. Trigger:AttrReference:"Text"2=where id=%Cid% order by colid
  679.  
  680. RIConstraint:Attrs:T=dbo.sysusers.name="Owner":name:0
  681. RIConstraint:AttrReference:"Owner"=uid=uid
  682.  
  683. Column:Attrs:T=dbo.systypes.name="Data Type":"Length"
  684. Column:AttrReference:"Data Type"=usertype=usertype
  685.  
  686. IndexColumn:Query1=select Id=c.colid, Name=INDEX_COL('%PN%', x.indid, c.colid)
  687. IndexColumn:Query2=from sysindexes x, syscolumns c
  688. IndexColumn:Query3=where (x.id = %Cid%) and (x.id = c.id) and
  689. IndexColumn:Query4=(x.name = '%N%') and (c.colid <= keycnt) and
  690. IndexColumn:Query5=(INDEX_COL('%PN%', x.indid, c.colid) != '')
  691. IndexColumn:Keys=Id
  692. IndexColumn:Attrs=Name=:0,Id=:0
  693. IndexColumn:Name=Name
  694.  
  695. Index:Values=keycnt:>0
  696.  
  697. FormalParameter:Attrs:T=dbo.systypes.name="Data Type":"Length"
  698. FormalParameter:AttrReference:"Data Type"=usertype=usertype
  699.  
  700. DataType:Actions=
  701. DataType:Attrs:T=dbo.sysusers.name="Owner":name:0
  702. DataType:AttrReference:"Owner"=uid=uid
  703.  
  704. User:Values=uid:<16384
  705.  
  706. [InterBase Properties]
  707. FieldType:Values1=7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  708. FieldType:Values2=11=double,14=CHAR,27=DOUBLE,35=DATE
  709. FieldType:Values3=37=VARCHAR,40=CSTRING,261=BLOB
  710. FieldSubType:Values1=0=,1="Text",2="BLR",3="ACL",4="Ranges",5="Summary"
  711. FieldSubType:Values2=6="Format",7="Transaction Desc",8="Ext File Desc"
  712. Boolean01:Values=="No",0="No",1="Yes"
  713. BlankYes:Values=="Yes",1="No"
  714. ParameterType:Values=0="Input",1="Output"
  715. TriggerType:Values1=1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  716. TriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  717.  
  718. InterBase:Objects1=O:"Domains"=Domain,O:"Tables"=Table,O:"Views"=View
  719. InterBase:Objects2=O:"Stored Procedures"=Procedure,O:"Triggers"=Trigger
  720. InterBase:Objects3=O:"Generators"=Generator,O:"Exceptions"=Exception
  721.  
  722. Table:Root=RDB$RELATIONS
  723. View:Root=RDB$RELATIONS
  724. Procedure:Root=RDB$PROCEDURES
  725. Trigger:Root=RDB$TRIGGERS
  726. PrimaryKey:Root=RDB$RELATION_CONSTRAINTS
  727. ForeignKey:Root=RDB$RELATION_CONSTRAINTS
  728. UniqueConstraint:Root=RDB$RELATION_CONSTRAINTS
  729. CheckConstraint:Root=RDB$RELATION_CONSTRAINTS
  730. Exception:Root=RDB$EXCEPTIONS
  731. Generator:Root=RDB$GENERATORS
  732. Index:Root=RDB$INDICES
  733. IndexColumn:Root=RDB$INDEX_SEGMENTS
  734. Column:Root=RDB$RELATION_FIELDS
  735. Domain:Root=RDB$FIELDS
  736. Enumeration:Root=RDB$TYPES
  737. FormalParameter:Root=RDB$PROCEDURE_PARAMETERS
  738.  
  739. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner",RDB$DESCRIPTION="Description"
  740. RDB$RELATIONS:Objects=T:"Columns"=Column
  741. RDB$RELATIONS:Name=RDB$RELATION_NAME
  742. RDB$RELATIONS:Reference:"Columns"=RDB$RELATION_NAME=RDB$RELATION_NAME
  743. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  744.  
  745. RDB$RELATION_FIELDS:Keys=RDB$FIELD_POSITION
  746. RDB$RELATION_FIELDS:Objects=T:"Domain"=Domain
  747. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  748. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  749.  
  750. RDB$FIELDS:Objects=T:"Values"=Enumeration
  751. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE="Type":::VM:FieldType
  752. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE="Subtype":::VM:FieldSubType
  753. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH="Length",RDB$FIELD_SCALE="Scale"
  754. RDB$FIELDS:Attrs4=RDB$NULL_FLAG="Nulls"::R:VM:BlankYes
  755. RDB$FIELDS:Attrs5=RDB$SEGMENT_LENGTH="Segment Size":2
  756. RDB$FIELDS:Attrs6=RDB$DEFAULT_SOURCE="Default":2:R
  757. RDB$FIELDS:Attrs7=RDB$VALIDATION_SOURCE="Constraint":2:R
  758. RDB$FIELDS:Attrs8=RDB$DESCRIPTION="Description"
  759. RDB$FIELDS:Name=RDB$FIELD_NAME
  760. RDB$FIELDS:Reference:"Values"=RDB$FIELD_NAME=RDB$FIELD_NAME
  761.  
  762. RDB$INDICES:Objects=T:"Columns"=IndexColumn
  763. RDB$INDICES:Attrs=RDB$UNIQUE_FLAG="Unique":::VM:Boolean01
  764. RDB$INDICES:Name=RDB$INDEX_NAME
  765. RDB$INDICES:Reference:"Columns"=RDB$INDEX_NAME=RDB$INDEX_NAME
  766. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  767.  
  768. RDB$INDEX_SEGMENTS:Keys=RDB$FIELD_POSITION
  769. RDB$INDEX_SEGMENTS:Name=RDB$FIELD_NAME
  770.  
  771. RDB$PROCEDURES:Objects=T:"Parameters"=FormalParameter
  772. RDB$PROCEDURES:Attrs=RDB$OWNER_NAME="Owner"
  773. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  774. RDB$PROCEDURES:Reference:"Parameters"=RDB$PROCEDURE_NAME=RDB$PROCEDURE_NAME
  775. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  776.  
  777. RDB$PROCEDURE_PARAMETERS:Keys=RDB$PARAMETER_TYPE,RDB$PARAMETER_NUMBER
  778. RDB$PROCEDURE_PARAMETERS:Objects=T:"Domain"=Domain
  779. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  780. RDB$PROCEDURE_PARAMETERS:Attrs=RDB$PARAMETER_TYPE="Parameter Kind":::VM:ParameterType
  781. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  782.  
  783. FormalParameter:Attrs:Q1="Type":2::VM:FieldType
  784. FormalParameter:Attrs:Q2="Subtype":2::VM:FieldSubType
  785. FormalParameter:Attrs:Q3="Length":2,"Scale":2
  786. FormalParameter:AttrReference:"Type"1=select RDB$FIELD_TYPE from RDB$FIELDS
  787. FormalParameter:AttrReference:"Type"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  788. FormalParameter:AttrReference:"Subtype"1=select RDB$FIELD_SUB_TYPE from RDB$FIELDS
  789. FormalParameter:AttrReference:"Subtype"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  790. FormalParameter:AttrReference:"Length"1=select RDB$FIELD_LENGTH from RDB$FIELDS
  791. FormalParameter:AttrReference:"Length"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  792. FormalParameter:AttrReference:"Scale"1=select RDB$FIELD_SCALE from RDB$FIELDS
  793. FormalParameter:AttrReference:"Scale"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  794.  
  795. RDB$TYPES:Keys=RDB$TYPE
  796. RDB$TYPES:Attrs=RDB$TYPE="Value"
  797. RDB$TYPES:Name=RDB$TYPE_NAME
  798. RDB$TYPES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  799.  
  800. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  801. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  802.  
  803. Generator:Attrs:Q="Current Value":2
  804. Generator:AttrReference:"Current Value"1=select distinct gen_id(%VRDB$GENERATOR_NAME%, 0)
  805. Generator:AttrReference:"Current Value"2=from RDB$GENERATORS
  806.  
  807. RDB$EXCEPTIONS:Keys=RDB$EXCEPTION_NUMBER
  808. RDB$EXCEPTIONS:Attrs=RDB$EXCEPTION_NUMBER="Code",RDB$MESSAGE="Message"
  809. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  810.  
  811. RDB$TRIGGERS:Objects=T:"Table"=Table
  812. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE="Type":::VM:TriggerType
  813. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE="Sequence"
  814. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  815. RDB$TRIGGERS:Reference:"Table"=RDB$RELATION_NAME=RDB$RELATION_NAME
  816. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  817.  
  818. RDB$RELATION_CONSTRAINTS:Objects=T:"Table"=Table,T:"Columns"=IndexColumn
  819. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  820. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  821. RDB$RELATION_CONSTRAINTS:Attrs3=RDB$INDEX_NAME="Index"
  822. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  823. RDB$RELATION_CONSTRAINTS:Reference:"Table"=RDB$RELATION_NAME=RDB$RELATION_NAME
  824. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME=RDB$INDEX_NAME
  825.  
  826. RDB$REF_CONSTRAINTS:Objects=T:"Primary Key"=PrimaryKey,T:"Foreign Key"=ForeignKey
  827. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  828. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  829. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  830. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  831. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  832. RDB$REF_CONSTRAINTS:Name=RDB$CONST_NAME_UQ
  833. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  834. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  835.  
  836. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  837. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  838.  
  839. Table:Values=RDB$VIEW_SOURCE:is null
  840. Table:Objects1=T:"Indices"=Index,T:"Primary Key"=PrimaryKey
  841. Table:Objects2=T:"Foreign Keys"=ForeignKey,T:"Check Constraints"=CheckConstraint
  842. Table:Objects3=T:"Unique Constraints"=UniqueConstraint,T:"Triggers"=Trigger
  843. Table:Actions=Data
  844. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  845. Table:Reference:"Primary Key"=RDB$RELATION_NAME=RDB$RELATION_NAME
  846. Table:Reference:"Foreign Keys"=RDB$RELATION_NAME=RDB$RELATION_NAME
  847. Table:Reference:"Check Constraints"=RDB$RELATION_NAME=RDB$RELATION_NAME
  848. Table:Reference:"Unique Constraints"=RDB$RELATION_NAME=RDB$RELATION_NAME
  849. Table:Reference:"Triggers"=RDB$RELATION_NAME=RDB$RELATION_NAME
  850. Table:Actions:Delete=DROP TABLE %N%
  851. Table:Actions:Save=COMMIT
  852.  
  853. View:Values=RDB$VIEW_SOURCE:is not null
  854. View:Actions=Data
  855. View:Attrs:Q="Text"
  856. View:AttrReference:"Text"1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  857. View:AttrReference:"Text"2=where RDB$RELATION_ID=%CRDB$RELATION_ID%
  858. View:Actions:Delete=DROP VIEW %N%
  859. View:Actions:Save=COMMIT
  860.  
  861. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_SCALE="Scale":RDB$RELATION_NAME
  862. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_LENGTH="Length":"Scale"
  863. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_SUB_TYPE="Subtype":"Length"
  864. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_TYPE="Type":"Subtype"
  865. Column:AttrReference:"Scale"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  866. Column:AttrReference:"Length"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  867. Column:AttrReference:"Subtype"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  868. Column:AttrReference:"Type"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  869.  
  870. Procedure:Actions=
  871. Procedure:Attrs:Q="Text"
  872. Procedure:AttrReference:"Text"1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  873. Procedure:AttrReference:"Text"2=where RDB$PROCEDURE_NAME=%CRDB$PROCEDURE_NAME%
  874.  
  875. UniqueConstraint:Values=RDB$CONSTRAINT_TYPE:=UNIQUE
  876.  
  877. CheckConstraint:Values=RDB$CONSTRAINT_TYPE:=CHECK
  878. CheckConstraint:Attrs:Q="Text"
  879. CheckConstraint:AttrReference:"Text"1=select t.RDB$TRIGGER_SOURCE
  880. CheckConstraint:AttrReference:"Text"2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  881. CheckConstraint:AttrReference:"Text"3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  882. CheckConstraint:AttrReference:"Text"4=t.RDB$TRIGGER_TYPE=1 and
  883. CheckConstraint:AttrReference:"Text"5=c.RDB$CONSTRAINT_NAME=%CRDB$CONSTRAINT_NAME%
  884.  
  885. PrimaryKey:Values=RDB$CONSTRAINT_TYPE:=PRIMARY KEY
  886.  
  887. ForeignKey:Values=RDB$CONSTRAINT_TYPE:=FOREIGN KEY
  888. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION="Match Option"
  889. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE="Update Rule"
  890. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE="Delete Rule"
  891. ForeignKey:AttrReference:"Match Option"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  892. ForeignKey:AttrReference:"Update Rule"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  893. ForeignKey:AttrReference:"Delete Rule"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  894.  
  895. Trigger:Actions=
  896. Trigger:Attrs:Q="Text"
  897. Trigger:AttrReference:"Text"1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  898. Trigger:AttrReference:"Text"2=where RDB$TRIGGER_NAME=%CRDB$TRIGGER_NAME%
  899.  
  900. [Informix Properties]
  901.  
  902.