home *** CD-ROM | disk | FTP | other *** search
/ PC Pro 1999 February / DPPCPRO0299.ISO / February / Delphi / Install / DATA.Z / DBX.DBI < prev    next >
Encoding:
Borland DataBase Explorer Information  |  1996-06-11  |  19.8 KB  |  421 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.  
  19. [Repository Properties]
  20. BDETypes:Values1=1="ZString",2="Date",3="Blob",4="Bool",5="Int16",6="Int32"
  21. BDETypes:Values2=7="Float",8="BCD",9="Bytes",10="Time",11="TimeStamp",12="UInt16"
  22. BDETypes:Values3=13="UInt32",14="IEEE Float",15="VarBytes",16="LockInfo"
  23.  
  24. BDESubTypes:Values1=0="",1="Password",21="Money",22="Memo",23="Binary"
  25. BDESubTypes:Values2=24="Formatted Memo",25="OLE Object",26="Graphic"
  26. BDESubTypes:Values3=27="DBase OLE Object",28="Typed Binary",29="Auto Increment"
  27.  
  28. TScale:Values=0=
  29. BooleanTF:Values=0="False",-1="True"
  30. TAlignment:Values=0="taLeftJustify",1="taRightJustify",2="taCenter"
  31.  
  32. TFieldType:Values1=0="ftUnknown",1="ftString",2="ftSmallint",3="ftInteger"
  33. TFieldType:Values2=4="ftWord",5="ftBoolean",6="ftFloat",7="ftCurrency",8="ftBCD"
  34. TFieldType:Values3=9="ftDate",10="ftTime",11="ftDateTime",12="ftBytes"
  35. TFieldType:Values4=13="ftVarBytes",14="ftAutoInc",15="ftBlob",16="ftMemo"
  36. TFieldType:Values5=17="ftGraphic",18="ftFmtMemo",19="ftParadoxOle"
  37. TFieldType:Values6=20="ftDBaseOle",21="ftTypedBinary"
  38.  
  39. TBlobType:Values1=15="ftBlob",16="ftMemo",17="ftGraphic",18="ftFmtMemo"
  40. TBlobType:Values2=19="ftParadoxOle",20="ftDBaseOle",21="ftTypedBinary"
  41.  
  42. DRDATABASES:Reference="Databases"
  43. DREXTFIELDS:Reference="Attribute Sets"
  44. DBTABLES:Reference="Tables"
  45. TABLEFLDS:Reference="Fields"
  46. FLDEXTFIELD:Reference="Attribute Set"
  47. EXTFIELDFLDS:Reference="Referencing Fields"
  48. PARENTEXTFIELD:Reference="Based On"
  49. CHILDEXTFIELD:Reference="Referencing Attribute Sets"
  50.  
  51. DATABASE:Attrs=DBPATH=::-E,DBTYPE=::-E
  52. TABLE:Attrs=PATH=:0,DRIVERTYPE=::-E,ISFILE=:0,ISVIEW=:0,ISSYNONYM=:0
  53. FIELD:Attrs1=PHYTYPE=::-E,LOGTYPE=::-E:VM:BDETypes,LOGSUBTYPE=::-E:VM:BDESubTypes
  54. FIELD:Attrs2=UNITS1=Size::-E,UNITS2=Scale::-E:VM:TScale,DEFVAL=:2:-E,MINVAL=:2:-E
  55. FIELD:Attrs3=MAXVAL=:2:-E,REQUIRED=:2:-E,READONLY=:2:-E
  56. EXTFIELD:Attrs1=ALIGNMENT=:::VM:TAlignment,READONLY=:::VM:BooleanTF
  57. EXTFIELD:Attrs2=REQUIRED=:::VM:BooleanTF,VISIBLE=:::VM:BooleanTF
  58. EXTFIELD:Attrs3=TRANSLITERATE=:::VM:BooleanTF,BLOBTYPE=:::VM:TBlobType
  59.  
  60. [Standard Properties]
  61. DriverType:Values=PARADOX="Paradox",DBASE="dBase"
  62. BooleanYesNo:Values=0="No",-1="Yes"
  63. FieldVChecks:Values=0="",1="Has Validity Checks",2=""
  64. FieldRights:Values=0="Read/Write",1="Read Only",2="None",3=""
  65. PrimaryIndex:Values=="<Primary>"
  66. LookupType:Values1=0="None",1="Current Field",2="All Corresponding"
  67. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  68. ReferenceType:Values=0="Master Of",1="Detail Of"
  69. ReferenceQual:Values=0="Restrict",1="Cascade"
  70. PrivilegeType:Values1=0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  71. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=""
  72. FamilyRightsType:Values=0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  73. FamilyMemberType:Values1=0="Unknown",1="Table",2="Index",3="Form",4="Report"
  74. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  75. FamilyMemberType:Values3=8="Blob File"
  76.  
  77. Standard:Objects=O:"Tables"=Table
  78.  
  79. Table:Attrs1=TYPE="Type"::NR:VM:DriverType,DATE="Date",TIME="Time",VERSION="Version":2
  80. Table:Attrs2=VALID="Valid":2::VM:BooleanYesNo,STRUCTURE="Structure":2
  81. Table:Attrs3=PROTECTED="Protected":2::VM:BooleanYesNo
  82. Table:Name=FILENAME,EXTENSION
  83. Table:Objects1=O:"Fields"=Column,O:"Indices"=Index,O:"Validity Checks"=ValCheck
  84. Table:Objects2=O:"Referential Constraints"=Reference,O:"Security Specs"=Security
  85. Table:Objects3=O:"Family Members"=Family
  86.  
  87. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  88. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  89. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  90.  
  91. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  92. Column:Attrs2=LENGTH="Physical Length"
  93. Column:Name=NAME
  94.  
  95. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  96. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  97. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  98. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  99. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  100. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  101.  
  102. Index:Attrs1=NAME=Name:0::VM:PrimaryIndex,TAGNAME=Tag:0,RESTRNUM="Version":2
  103. Index:Attrs2=PRIMARY="Primary Key":::VM:BooleanYesNo,UNIQUE="Unique"::NR:VM:BooleanYesNo
  104. Index:Attrs3=AUTO="Maintained":2::VM:BooleanYesNo
  105. Index:Attrs4=OUTOFDATE="Out of Date":2::VM:BooleanYesNo
  106. Index:Attrs5=FORMAT="Format":2,BLOCKSIZE="Block Size":2
  107. Index:Attrs6=CASEINSENSITIVE="Case Insensitive":2:NR:VM:BooleanYesNo
  108. Index:Attrs7=DESCENDING="Descending":2:NR:VM:BooleanYesNo
  109. Index:Attrs8=EXPRESSION="Expression":2:N
  110. Index:Attrs9=CONDITION="Subset Condition":2:N
  111. Index:Name=Name,Tag
  112.  
  113. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  114. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  115. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  116. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  117.  
  118. ValCheck:Attrs1=FIELDNUM="Field":2:NR,REQUIRED="Required":1:NR:VM:BooleanYesNo
  119. ValCheck:Attrs2=MINVALUE="Min Value":1:N,MAXVALUE="Max Value":1:N
  120. ValCheck:Attrs3=DEFAULT="Default Value":1:N,PICTURE="Picture":2:N
  121. ValCheck:Name="Field"
  122.  
  123. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  124.  
  125. Family:Attrs=TYPE="Type":1::VM:FamilyMemberType,NAME="Object Name":1
  126. Family:Name=FILENAME
  127.  
  128. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  129. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  130. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  131.  
  132. Reference:Attrs1=TYPE="Reference Type":1::VM:ReferenceType
  133. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  134. Reference:Attrs3=MODOP="Modify Operation":1:NR:VM:ReferenceQual
  135. Reference:Attrs4=DELOP="Delete Operation":1:NR:VM:ReferenceQual
  136. Reference:Name=NAME
  137.  
  138. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  139. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  140.  
  141. Security:Attrs1=TYPE="Table Rights":1:NR:VM:PrivilegeType
  142. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:VS:FamilyRightsType:$0F
  143. Security:Name=PASSWORD
  144.  
  145. [ODBC Properties]
  146. DriverType:Values=PARADOX="Paradox",DBASE="dBase"
  147. BooleanYesNo:Values=0="No",-1="Yes"
  148. FieldVChecks:Values=0="",1="Has Validity Checks",2=""
  149. FieldRights:Values=0="Read/Write",1="Read Only",2="None",3=""
  150. PrimaryIndex:Values=="<Primary>"
  151. LookupType:Values1=0="None",1="Current Field",2="All Corresponding"
  152. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  153. ReferenceType:Values=0="Master Of",1="Detail Of"
  154. ReferenceQual:Values=0="Restrict",1="Cascade"
  155. PrivilegeType:Values1=0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  156. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=""
  157. FamilyRightsType:Values=0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  158.  
  159. ODBC:Objects=O:"Tables"=Table,O:"Stored Procedures"=Procedure
  160.  
  161. Table:Attrs1=TYPE="Type"::NR:VM:DriverType,DATE="Date",TIME="Time",VERSION="Version":2
  162. Table:Attrs2=VALID="Valid":2::VM:BooleanYesNo,STRUCTURE="Structure":2
  163. Table:Attrs3=PROTECTED="Protected":2::VM:BooleanYesNo
  164. Table:Name=FILENAME,EXTENSION
  165. Table:Objects1=O:"Fields"=Column,O:"Indices"=Index,O:"Validity Checks"=ValCheck
  166. Table:Objects2=O:"Referential Constraints"=Reference,O:"Security Specs"=Security
  167.  
  168. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  169. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  170. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  171.  
  172. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  173. Column:Attrs2=LENGTH="Physical Length"
  174. Column:Name=NAME
  175.  
  176. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  177. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  178. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  179. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  180. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  181. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  182.  
  183. Index:Attrs1=NAME=Name:0::VM:PrimaryIndex,TAGNAME=Tag:0,RESTRNUM="Version":2
  184. Index:Attrs2=PRIMARY="Primary Key":::VM:BooleanYesNo,UNIQUE="Unique"::NR:VM:BooleanYesNo
  185. Index:Attrs3=AUTO="Maintained":2::VM:BooleanYesNo
  186. Index:Attrs4=OUTOFDATE="Out of Date":2::VM:BooleanYesNo
  187. Index:Attrs5=FORMAT="Format":2,BLOCKSIZE="Block Size":2
  188. Index:Attrs6=CASEINSENSITIVE="Case Insensitive":2:NR:VM:BooleanYesNo
  189. Index:Attrs7=DESCENDING="Descending":2:NR:VM:BooleanYesNo
  190. Index:Attrs8=EXPRESSION="Expression":2:N
  191. Index:Attrs9=CONDITION="Subset Condition":2:N
  192. Index:Name=Name,Tag
  193.  
  194. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  195. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  196. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  197. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  198.  
  199. ValCheck:Attrs1=FIELDNUM="Field":2:NR,REQUIRED="Required":1:NR:VM:BooleanYesNo
  200. ValCheck:Attrs2=MINVALUE="Min Value":1:N,MAXVALUE="Max Value":1:N
  201. ValCheck:Attrs3=DEFAULT="Default Value":1:N,PICTURE="Picture":2:N
  202. ValCheck:Name="Field"
  203.  
  204. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  205. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  206. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  207.  
  208. Reference:Attrs1=TYPE="Reference Type":1::VM:ReferenceType
  209. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  210. Reference:Attrs3=MODOP="Modify Operation":1:NR:VM:ReferenceQual
  211. Reference:Attrs4=DELOP="Delete Operation":1:NR:VM:ReferenceQual
  212. Reference:Name=NAME
  213.  
  214. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  215. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  216.  
  217. Security:Attrs1=TYPE="Table Rights":1:NR:VM:PrivilegeType
  218. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:VS:FamilyRightsType:$0F
  219. Security:Name=PASSWORD
  220.  
  221. Procedure:Name=NAME
  222.  
  223.  
  224.  
  225.  
  226. [InterBase Properties]
  227. FieldType:Values1=7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  228. FieldType:Values2=11=double,14=CHAR,27=DOUBLE,35=DATE
  229. FieldType:Values3=37=VARCHAR,40=CSTRING,261=BLOB
  230. FieldSubType:Values1=0=,1="Text",2="BLR",3="ACL",4="Ranges",5="Summary"
  231. FieldSubType:Values2=6="Format",7="Transaction Desc",8="Ext File Desc"
  232. Boolean01:Values=="No",0="No",1="Yes"
  233. BlankYes:Values=="Yes",1="No"
  234. ParameterType:Values=0="Input",1="Output"
  235. TriggerType:Values1=1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  236. TriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  237.  
  238. InterBase:Objects1=O:"Domains"=Domain,O:"Tables"=Table,O:"Views"=View
  239. InterBase:Objects2=O:"Stored Procedures"=Procedure,O:"Triggers"=Trigger
  240. InterBase:Objects3=O:"Generators"=Generator,O:"Exceptions"=Exception
  241.  
  242. Table:Root=RDB$RELATIONS
  243. View:Root=RDB$RELATIONS
  244. Procedure:Root=RDB$PROCEDURES
  245. Trigger:Root=RDB$TRIGGERS
  246. PrimaryKey:Root=RDB$RELATION_CONSTRAINTS
  247. ForeignKey:Root=RDB$RELATION_CONSTRAINTS
  248. UniqueConstraint:Root=RDB$RELATION_CONSTRAINTS
  249. CheckConstraint:Root=RDB$RELATION_CONSTRAINTS
  250. Exception:Root=RDB$EXCEPTIONS
  251. Generator:Root=RDB$GENERATORS
  252. Index:Root=RDB$INDICES
  253. IndexColumn:Root=RDB$INDEX_SEGMENTS
  254. Column:Root=RDB$RELATION_FIELDS
  255. Domain:Root=RDB$FIELDS
  256. Enumeration:Root=RDB$TYPES
  257. FormalParameter:Root=RDB$PROCEDURE_PARAMETERS
  258.  
  259. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner",RDB$DESCRIPTION="Description"
  260. RDB$RELATIONS:Objects=T:"Columns"=Column
  261. RDB$RELATIONS:Name=RDB$RELATION_NAME
  262. RDB$RELATIONS:Reference:"Columns"=RDB$RELATION_NAME=RDB$RELATION_NAME
  263. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  264.  
  265. RDB$RELATION_FIELDS:Keys=RDB$FIELD_POSITION
  266. RDB$RELATION_FIELDS:Objects=T:"Domain"=Domain
  267. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  268. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  269.  
  270. RDB$FIELDS:Objects=T:"Values"=Enumeration
  271. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE="Type":::VM:FieldType
  272. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE="Subtype":::VM:FieldSubType
  273. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH="Length",RDB$FIELD_SCALE="Scale"
  274. RDB$FIELDS:Attrs4=RDB$NULL_FLAG="Nulls"::R:VM:BlankYes
  275. RDB$FIELDS:Attrs5=RDB$SEGMENT_LENGTH="Segment Size":2
  276. RDB$FIELDS:Attrs6=RDB$DEFAULT_SOURCE="Default":2:R
  277. RDB$FIELDS:Attrs7=RDB$VALIDATION_SOURCE="Constraint":2:R
  278. RDB$FIELDS:Attrs8=RDB$DESCRIPTION="Description"
  279. RDB$FIELDS:Name=RDB$FIELD_NAME
  280. RDB$FIELDS:Reference:"Values"=RDB$FIELD_NAME=RDB$FIELD_NAME
  281.  
  282. RDB$INDICES:Objects=T:"Columns"=IndexColumn
  283. RDB$INDICES:Attrs=RDB$UNIQUE_FLAG="Unique":::VM:Boolean01
  284. RDB$INDICES:Name=RDB$INDEX_NAME
  285. RDB$INDICES:Reference:"Columns"=RDB$INDEX_NAME=RDB$INDEX_NAME
  286. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  287.  
  288. RDB$INDEX_SEGMENTS:Keys=RDB$FIELD_POSITION
  289. RDB$INDEX_SEGMENTS:Name=RDB$FIELD_NAME
  290.  
  291. RDB$PROCEDURES:Objects=T:"Parameters"=FormalParameter
  292. RDB$PROCEDURES:Attrs=RDB$OWNER_NAME="Owner"
  293. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  294. RDB$PROCEDURES:Reference:"Parameters"=RDB$PROCEDURE_NAME=RDB$PROCEDURE_NAME
  295. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  296.  
  297. RDB$PROCEDURE_PARAMETERS:Keys=RDB$PARAMETER_TYPE,RDB$PARAMETER_NUMBER
  298. RDB$PROCEDURE_PARAMETERS:Objects=T:"Domain"=Domain
  299. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  300. RDB$PROCEDURE_PARAMETERS:Attrs=RDB$PARAMETER_TYPE="Parameter Kind":::VM:ParameterType
  301. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  302.  
  303. FormalParameter:Attrs:Q1="Type":2::VM:FieldType
  304. FormalParameter:Attrs:Q2="Subtype":2::VM:FieldSubType
  305. FormalParameter:Attrs:Q3="Length":2,"Scale":2
  306. FormalParameter:AttrReference:"Type"1=select RDB$FIELD_TYPE from RDB$FIELDS
  307. FormalParameter:AttrReference:"Type"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  308. FormalParameter:AttrReference:"Subtype"1=select RDB$FIELD_SUB_TYPE from RDB$FIELDS
  309. FormalParameter:AttrReference:"Subtype"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  310. FormalParameter:AttrReference:"Length"1=select RDB$FIELD_LENGTH from RDB$FIELDS
  311. FormalParameter:AttrReference:"Length"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  312. FormalParameter:AttrReference:"Scale"1=select RDB$FIELD_SCALE from RDB$FIELDS
  313. FormalParameter:AttrReference:"Scale"2=where RDB$FIELD_NAME = %CRDB$FIELD_SOURCE%
  314.  
  315. RDB$TYPES:Keys=RDB$TYPE
  316. RDB$TYPES:Attrs=RDB$TYPE="Value"
  317. RDB$TYPES:Name=RDB$TYPE_NAME
  318. RDB$TYPES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  319.  
  320. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  321. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  322.  
  323. Generator:Attrs:Q="Current Value":2
  324. Generator:AttrReference:"Current Value"1=select distinct gen_id(%VRDB$GENERATOR_NAME%, 0)
  325. Generator:AttrReference:"Current Value"2=from RDB$GENERATORS
  326.  
  327. RDB$EXCEPTIONS:Keys=RDB$EXCEPTION_NUMBER
  328. RDB$EXCEPTIONS:Attrs=RDB$EXCEPTION_NUMBER="Code",RDB$MESSAGE="Message"
  329. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  330.  
  331. RDB$TRIGGERS:Objects=T:"Table"=Table
  332. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE="Type":::VM:TriggerType
  333. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE="Sequence"
  334. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  335. RDB$TRIGGERS:Reference:"Table"=RDB$RELATION_NAME=RDB$RELATION_NAME
  336. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  337.  
  338. RDB$RELATION_CONSTRAINTS:Objects=T:"Table"=Table,T:"Columns"=IndexColumn
  339. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  340. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  341. RDB$RELATION_CONSTRAINTS:Attrs3=RDB$INDEX_NAME="Index"
  342. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  343. RDB$RELATION_CONSTRAINTS:Reference:"Table"=RDB$RELATION_NAME=RDB$RELATION_NAME
  344. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME=RDB$INDEX_NAME
  345.  
  346. RDB$REF_CONSTRAINTS:Objects=T:"Primary Key"=PrimaryKey,T:"Foreign Key"=ForeignKey
  347. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  348. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  349. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  350. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  351. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  352. RDB$REF_CONSTRAINTS:Name=RDB$CONST_NAME_UQ
  353. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  354. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  355.  
  356. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  357. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  358.  
  359. Table:Values=RDB$VIEW_SOURCE:is null
  360. Table:Objects1=T:"Indices"=Index,T:"Primary Key"=PrimaryKey
  361. Table:Objects2=T:"Foreign Keys"=ForeignKey,T:"Check Constraints"=CheckConstraint
  362. Table:Objects3=T:"Unique Constraints"=UniqueConstraint,T:"Triggers"=Trigger
  363. Table:Actions=Data
  364. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  365. Table:Reference:"Primary Key"=RDB$RELATION_NAME=RDB$RELATION_NAME
  366. Table:Reference:"Foreign Keys"=RDB$RELATION_NAME=RDB$RELATION_NAME
  367. Table:Reference:"Check Constraints"=RDB$RELATION_NAME=RDB$RELATION_NAME
  368. Table:Reference:"Unique Constraints"=RDB$RELATION_NAME=RDB$RELATION_NAME
  369. Table:Reference:"Triggers"=RDB$RELATION_NAME=RDB$RELATION_NAME
  370. Table:Actions:Delete=DROP TABLE %N%
  371. Table:Actions:Save=COMMIT
  372.  
  373. View:Values=RDB$VIEW_SOURCE:is not null
  374. View:Actions=Data
  375. View:Attrs:Q="Text"
  376. View:AttrReference:"Text"1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  377. View:AttrReference:"Text"2=where RDB$RELATION_ID=%CRDB$RELATION_ID%
  378. View:Actions:Delete=DROP VIEW %N%
  379. View:Actions:Save=COMMIT
  380.  
  381. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_SCALE="Scale":RDB$RELATION_NAME
  382. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_LENGTH="Length":"Scale"
  383. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_SUB_TYPE="Subtype":"Length"
  384. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_TYPE="Type":"Subtype"
  385. Column:AttrReference:"Scale"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  386. Column:AttrReference:"Length"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  387. Column:AttrReference:"Subtype"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  388. Column:AttrReference:"Type"=RDB$FIELD_SOURCE=RDB$FIELD_NAME
  389.  
  390. Procedure:Actions=
  391. Procedure:Attrs:Q="Text"
  392. Procedure:AttrReference:"Text"1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  393. Procedure:AttrReference:"Text"2=where RDB$PROCEDURE_NAME=%CRDB$PROCEDURE_NAME%
  394.  
  395. UniqueConstraint:Values=RDB$CONSTRAINT_TYPE:=UNIQUE
  396.  
  397. CheckConstraint:Values=RDB$CONSTRAINT_TYPE:=CHECK
  398. CheckConstraint:Attrs:Q="Text"
  399. CheckConstraint:AttrReference:"Text"1=select t.RDB$TRIGGER_SOURCE
  400. CheckConstraint:AttrReference:"Text"2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  401. CheckConstraint:AttrReference:"Text"3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  402. CheckConstraint:AttrReference:"Text"4=t.RDB$TRIGGER_TYPE=1 and
  403. CheckConstraint:AttrReference:"Text"5=c.RDB$CONSTRAINT_NAME=%CRDB$CONSTRAINT_NAME%
  404.  
  405. PrimaryKey:Values=RDB$CONSTRAINT_TYPE:=PRIMARY KEY
  406.  
  407. ForeignKey:Values=RDB$CONSTRAINT_TYPE:=FOREIGN KEY
  408. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION="Match Option"
  409. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE="Update Rule"
  410. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE="Delete Rule"
  411. ForeignKey:AttrReference:"Match Option"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  412. ForeignKey:AttrReference:"Update Rule"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  413. ForeignKey:AttrReference:"Delete Rule"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  414.  
  415. Trigger:Actions=
  416. Trigger:Attrs:Q="Text"
  417. Trigger:AttrReference:"Text"1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  418. Trigger:AttrReference:"Text"2=where RDB$TRIGGER_NAME=%CRDB$TRIGGER_NAME%
  419.  
  420.  
  421.