home *** CD-ROM | disk | FTP | other *** search
/ QBasic & Borland Pascal & C / Delphi5.iso / Runimage / Delphi50 / Bin / DBX.DBI < prev    next >
Encoding:
Text File  |  1999-08-11  |  143.2 KB  |  3,326 lines
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.  
  11.  
  12.  
  13.  
  14.  
  15.  
  16.  
  17.  
  18.  
  19.  
  20.  
  21.  
  22.  
  23.  
  24.  
  25.  
  26.  
  27.  
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41.  
  42.  
  43.  
  44.  
  45.  
  46.  
  47.  
  48.  
  49.  
  50.  
  51.  
  52.  
  53.  
  54.  
  55.  
  56.  
  57.  
  58.  
  59.  
  60.  
  61.  
  62.  
  63.  
  64.  
  65.  
  66.  
  67.  
  68.  
  69.  
  70.  
  71.  
  72.  
  73.  
  74.  
  75.  
  76.  
  77.  
  78.  
  79.  
  80.  
  81.  
  82.  
  83.  
  84.  
  85. [Version]
  86.  
  87. DbXName="SQL Explorer"
  88.  
  89.  
  90.  
  91.  
  92.  
  93.  
  94.  
  95.  
  96.  
  97.  
  98. DbXDR=True
  99.  
  100. DbXVersion=3.00
  101.  
  102. [Properties]
  103. DEFAULT DRIVER:Values=Closed,PARADOX,DBASE,FOXPRO,ASCIIDRV
  104. NET PROTOCOL:Values1=Closed,TNS,TCP/IP,SPX/IPX,NETBIOS,NAMED PIPES,DECNET,3270,VINES
  105. NET PROTOCOL:Values2=APPC,ASYNC
  106. OPEN MODE:Values=Closed,READ/WRITE,READ ONLY
  107. SHARE MODE:Values=Closed,EXCLUSIVE,SHARED
  108. STRICTINTEGRTY:Values=Closed,FALSE,TRUE
  109. SQLPASSTHRU MODE:Values=Closed,NOT SHARED,SHARED AUTOCOMMIT,SHARED NOAUTOCOMMIT
  110. LIST SYNONYMS:Values=Closed,NONE,ALL,PRIVATE
  111. BLOB EDIT LOGGING:Values=Closed,FALSE,TRUE
  112. ENABLE SCHEMA CACHE:Values=Closed,FALSE,TRUE
  113. ENABLE BCD:Values=Closed,FALSE,TRUE
  114. ENABLE INTEGERS:Values=Closed,FALSE,TRUE
  115. LOCAL SHARE:Values=Closed,FALSE,TRUE
  116. MTS POOLING:Values=Closed,FALSE,TRUE
  117. OBJECT MODE:Values=Closed,FALSE,TRUE
  118. AUTO ODBC:Values=Closed,FALSE,TRUE
  119. FOURDIGITYEAR:Values=Closed,FALSE,TRUE
  120. YEARBIASED:Values=Closed,FALSE,TRUE
  121. LEADINGZEROM:Values=Closed,FALSE,TRUE
  122. LEADINGZEROD:Values=Closed,FALSE,TRUE
  123. TWELVEHOUR:Values=Closed,FALSE,TRUE
  124. SECONDS:Values=Closed,FALSE,TRUE
  125. MILSECONDS:Values=Closed,FALSE,TRUE
  126. LEADINGZERON:Values=Closed,FALSE,TRUE
  127. COLLCHAR:Values=Closed,0,1,2
  128. DBNLS:Values=Closed,0,1,2
  129. SQLQRYMODE:Values=Closed,LOCAL,SERVER
  130.  
  131. :HelpContext=4039
  132. DB2:HelpContext=4038
  133. INFORMIX:HelpContext=4035
  134. INTRBASE:HelpContext=4037
  135. MSACCESS:HelpContext=4042
  136. MSSQL:HelpContext=4036
  137. ORACLE:HelpContext=4034
  138. STANDARD:HelpContext=4045
  139. SYBASE:HelpContext=4033
  140.  
  141.  
  142. MSSQL:Identity=select substring(@@version,1,charindex(char(0x0a),@@version)-1)
  143. MSSQL:IdentityRE=SQL Server [^0-9]*([0-9]+)\.
  144.  
  145. SYBASE:Identity=select @@version
  146. SYBASE:IdentityRE=SQL Server/([0-9]+)\.
  147. SYBASE:IdentityMap:11=10
  148.  
  149. ORACLE:Identity=select 'Oracle ' || VERSION_TEXT from SM$VERSION
  150. ORACLE:IdentityRE=([0-9]+\.[0-9]*)
  151. ORACLE:IdentityMap:7.3=7.2
  152.  
  153. INFORMIX:Identity=select 'Informix ' || owner from informix.systables where tabid=99
  154. INFORMIX:IdentityRE=([0-9]+)\.
  155.  
  156. DB2:IdentityMap:DB2/2=Common Server
  157. DB2:IdentityMap:DB2/NT=Common Server
  158. DB2:IdentityMap:DB2/AIX=Common Server
  159.  
  160.  
  161.  
  162. [DATAREP Properties]
  163. BDETypes:Values1=Closed,1=ZString,2=Date,3=Blob,4=Bool,5=Int16,6=Int32
  164. BDETypes:Values2=7=Float,8=BCD,9=Bytes,10=Time,11=TimeStamp,12=UInt16
  165. BDETypes:Values3=13=UInt32,14=IEEE Float,15=VarBytes,16=LockInfo
  166. BDETypes:Values4=17=Cursor,18=Int64,19=UInt64,20=ADT,21=Array,22=Ref,23=Table
  167.  
  168. BDESubTypes:Values1=Closed,0=,1=Password,21=Money,22=Memo,23=Binary
  169. BDESubTypes:Values2=24=Formatted Memo,25=OLE Object,26=Graphic
  170. BDESubTypes:Values3=27=DBase OLE Object,28=Typed Binary,29=Auto Increment
  171.  
  172. TScale:Values=Open,0=
  173. TBooleanTF:Values=Closed,0=False,-1=True
  174. TAlignment:Values=Closed,0=taLeftJustify,1=taRightJustify,2=taCenter
  175.  
  176. TFieldType:Values1=Closed,0=ftUnknown,1=ftString,2=ftSmallint,3=ftInteger
  177. TFieldType:Values2=4=ftWord,5=ftBoolean,6=ftFloat,7=ftCurrency,8=ftBCD
  178. TFieldType:Values3=9=ftDate,10=ftTime,11=ftDateTime,12=ftBytes
  179. TFieldType:Values4=13=ftVarBytes,14=ftAutoInc,15=ftBlob,16=ftMemo
  180. TFieldType:Values5=17=ftGraphic,18=ftFmtMemo,19=ftParadoxOle
  181. TFieldType:Values6=20=ftDBaseOle,21=ftTypedBinary
  182.  
  183. TBlobType:Values1=Closed,15=ftBlob,16=ftMemo,17=ftGraphic,18=ftFmtMemo
  184. TBlobType:Values2=19=ftParadoxOle,20=ftDBaseOle,21=ftTypedBinary
  185.  
  186. DRDATABASES:Reference="Databases"
  187. DREXTFIELDS:Reference="Attribute Sets"
  188. DBTABLES:Reference="Tables"
  189. TABLEFLDS:Reference="Fields"
  190. FLDEXTFIELD:Reference="Attribute Set"
  191. EXTFIELDFLDS:Reference="Referencing Fields"
  192. PARENTEXTFIELD:Reference="Based On"
  193. CHILDEXTFIELD:Reference="Referencing Attribute Sets"
  194.  
  195. DATABASE:Category=Database
  196. DATABASE:NameRE=.*
  197. DATABASE:Attrs=DBPATH="Path":0:-E,DBTYPE="Type"::-E
  198.  
  199. TABLE:Category=Dataset
  200. TABLE:NameRE=.*
  201. TABLE:Attrs=PATH=:0,DRIVERTYPE="Type"::-E,ISFILE=:0,ISVIEW=:0,ISSYNONYM=:0
  202.  
  203. FIELD:Category=Column
  204. FIELD:Attrs1=PHYTYPE="Physical Type"::-E
  205. FIELD:Attrs2=LOGTYPE="Logical Type"::-E:::VM=BDETypes
  206. FIELD:Attrs3=LOGSUBTYPE="Logical Subtype"::-E:::VM=BDESubTypes
  207. FIELD:Attrs4=UNITS1="Size"::-E
  208. FIELD:Attrs5=UNITS2="Scale"::-E:::VM=TScale
  209. FIELD:Attrs6=DEFVAL=:2:-E
  210. FIELD:Attrs7=MINVAL=:2:-E
  211. FIELD:Attrs8=MAXVAL=:2:-E
  212. FIELD:Attrs9=REQUIRED=:2:-E:::VM=TBooleanTF
  213. FIELD:Attrs10=READONLY=:2:-E:::VM=TBooleanTF
  214.  
  215. EXTFIELD:NameRE=.*
  216. EXTFIELD:Attrs1=FIELDCLASS=:1
  217. EXTFIELD:Attrs2=CONTROLCLASS=:1
  218. EXTFIELD:Attrs3=ALIGNMENT=:2::::VM=TAlignment
  219. EXTFIELD:Attrs4=DISPLABEL=:2
  220. EXTFIELD:Attrs5=DISPWIDTH=:2
  221. EXTFIELD:Attrs6=READONLY=:2::::VM=TBooleanTF
  222. EXTFIELD:Attrs7=REQUIRED=:2::::VM=TBooleanTF
  223. EXTFIELD:Attrs8=VISIBLE=:2::::VM=TBooleanTF
  224. EXTFIELD:Attrs9=TRANSLITERATE=:2::::VM=TBooleanTF
  225. EXTFIELD:Attrs10=EDITMASK=:2
  226. EXTFIELD:Attrs11=DISPFORMAT=:2
  227. EXTFIELD:Attrs12=EDITFORMAT=:2
  228. EXTFIELD:Attrs13=MINVAL=:2
  229. EXTFIELD:Attrs14=MAXVAL=:2
  230. EXTFIELD:Attrs15=CURRENCY=:2::::VM=TBooleanTF
  231. EXTFIELD:Attrs16=PRECISION=:2
  232. EXTFIELD:Attrs17=DISPLAYVALUES=:2
  233. EXTFIELD:Attrs18=BLOBTYPE=:2::::VM=TBlobType
  234.  
  235. [DATAREP 20 Properties]
  236. TABLECONSTRS:Reference="Check Constraints"
  237.  
  238. CONSTRAINT:NameRE=.*
  239. CONSTRAINT:Attrs1=SRVCHECK=:2:-E
  240. CONSTRAINT:Attrs2=LOCCHECK=:2
  241. CONSTRAINT:Attrs3=ERRORSTR=:2
  242.  
  243. EXTFIELD:Attrs1=SRVDOMAINNAME=:1:-E
  244. EXTFIELD:Attrs2=FIELDCLASS=:1
  245. EXTFIELD:Attrs3=CONTROLCLASS=:1
  246. EXTFIELD:Attrs4=ALIGNMENT=:2::::VM=TAlignment
  247. EXTFIELD:Attrs5=DISPLABEL=:2
  248. EXTFIELD:Attrs6=DISPWIDTH=:2
  249. EXTFIELD:Attrs7=READONLY=:2::::VM=TBooleanTF
  250. EXTFIELD:Attrs8=REQUIRED=:2::::VM=TBooleanTF
  251. EXTFIELD:Attrs9=VISIBLE=:2::::VM=TBooleanTF
  252. EXTFIELD:Attrs10=TRANSLITERATE=:2::::VM=TBooleanTF
  253. EXTFIELD:Attrs11=EDITMASK=:2
  254. EXTFIELD:Attrs12=DISPFORMAT=:2
  255. EXTFIELD:Attrs13=EDITFORMAT=:2
  256. EXTFIELD:Attrs14=MINVAL=:2
  257. EXTFIELD:Attrs15=MAXVAL=:2
  258. EXTFIELD:Attrs16=CURRENCY=:2::::VM=TBooleanTF
  259. EXTFIELD:Attrs17=PRECISION=:2
  260. EXTFIELD:Attrs18=DISPLAYVALUES=:2
  261. EXTFIELD:Attrs19=BLOBTYPE=:2::::VM=TBlobType
  262. EXTFIELD:Attrs20=DEFAULT=:2
  263. EXTFIELD:Attrs21=SRVCHECK=:2:-E
  264. EXTFIELD:Attrs22=LOCCHECK=:2
  265. EXTFIELD:Attrs23=ERRORSTR=:2
  266.  
  267.  
  268.  
  269. [STANDARD Properties]
  270. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  271. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  272. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  273. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  274. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  275. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  276. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  277. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  278. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  279. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  280. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  281. FamilyMemberType:Values1=Closed,0="Unknown",1="Table",2="Index",3="Form",4="Report"
  282. FamilyMemberType:Values2=5="Validity Checks",6="Secondary Index",7="Secondary Index"
  283. FamilyMemberType:Values3=8="Blob File"
  284.  
  285. STANDARD:Objects=O:C:0M::"Tables":Table
  286.  
  287. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  288. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  289. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  290. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  291. Table:Dataset5=PROTECTED=Word,VALID=Word
  292.  
  293. Table:Category=Dataset
  294. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  295. Table:Attrs2=DATE="Date"
  296. Table:Attrs3=TIME="Time"
  297. Table:Attrs4=VERSION="Version":2
  298. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  299. Table:Attrs6=STRUCTURE="Structure":2
  300. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  301. Table:Name=FILENAME,EXTENSION
  302. Table:Objects1=O:P:1M::"Fields":Column
  303. Table:Objects2=O:O:0M::"Indices":Index
  304. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  305. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  306. Table:Objects5=O:O:0M::"Security Specs":Security
  307. Table:Objects6=O:C:1M::"Family Members":Family
  308.  
  309. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  310. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  311. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  312.  
  313. Column:Category=Column
  314. Column:Order=FIELDNUM
  315. Column:Attrs1=FIELDNUM="Order":2:NR
  316. Column:Attrs2=TYPE="Type":1:NR
  317. Column:Attrs3=UNITS1="Size":1:N
  318. Column:Attrs4=UNITS2="Scale":1:N
  319. Column:Attrs5=LENGTH="Physical Length"
  320. Column:Name=NAME
  321.  
  322. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  323. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  324. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  325. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  326. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  327. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  328.  
  329. Index:Category=Index
  330. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  331. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  332. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  333. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  334. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  335. Index:Attrs6=FORMAT="Format":2
  336. Index:Attrs7=BLOCKSIZE="Block Size":2
  337. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  338. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  339. Index:Attrs10=EXPRESSION="Expression":2:N
  340. Index:Attrs11=CONDITION="Subset Condition":2:N
  341. Index:Name=NAME
  342. Index:OnAfterLoad=GetIndexInfo
  343.  
  344. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  345. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  346. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  347. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  348.  
  349. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  350. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  351. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  352. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  353. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  354. ValCheck:Attrs6=PICTURE="Picture":2:N
  355. ValCheck:Name=FIELDNUM
  356.  
  357. Family:Dataset=NAME=String:32,ID=Word,TYPE=Integer,FILENAME=String:261
  358.  
  359. Family:Attrs1=TYPE="Type":1::::VM=FamilyMemberType
  360. Family:Attrs2=NAME="Object Name":1
  361. Family:Name=FILENAME
  362.  
  363. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  364. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  365. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  366.  
  367. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  368. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  369. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  370. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  371. Reference:Name=NAME
  372. Reference:OnAfterLoad=GetReferenceInfo
  373.  
  374. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  375. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  376.  
  377. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  378. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  379. Security:Name=PASSWORD
  380.  
  381. [MSACCESS Properties]
  382. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  383. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  384. FieldVChecks:Values=Closed,0="",1="Has Validity Checks",2=""
  385. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=""
  386. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  387. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  388. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  389. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  390. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  391. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  392. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  393.  
  394. MSACCESS:Objects=O:C:0M::"Tables":Table
  395.  
  396. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  397. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  398. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  399. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  400. Table:Dataset5=PROTECTED=Word,VALID=Word
  401.  
  402. Table:Category=Dataset
  403. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  404. Table:Attrs2=DATE="Date"
  405. Table:Attrs3=TIME="Time"
  406. Table:Attrs4=VERSION="Version":2
  407. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  408. Table:Attrs6=STRUCTURE="Structure":2
  409. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  410. Table:Name=FILENAME,EXTENSION
  411. Table:Objects1=O:P:1M::"Fields":Column
  412. Table:Objects2=O:O:0M::"Indices":Index
  413. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  414. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  415. Table:Objects5=O:O:0M::"Security Specs":Security
  416.  
  417. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  418. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  419. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  420.  
  421. Column:Category=Column
  422. Column:Attrs1=TYPE="Type":1:NR,UNITS1="Size":1:N,UNITS2="Scale":1:N
  423. Column:Attrs2=LENGTH="Physical Length"
  424. Column:Name=NAME
  425.  
  426. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  427. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  428. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  429. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  430. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  431. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  432.  
  433. Index:Category=Index
  434. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  435. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  436. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  437. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  438. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  439. Index:Attrs6=FORMAT="Format":2
  440. Index:Attrs7=BLOCKSIZE="Block Size":2
  441. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  442. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  443. Index:Attrs10=EXPRESSION="Expression":2:N
  444. Index:Attrs11=CONDITION="Subset Condition":2:N
  445. Index:Name=NAME
  446. Index:OnAfterLoad=GetIndexInfo
  447.  
  448. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  449. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  450. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  451. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  452.  
  453. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  454. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  455. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  456. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  457. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  458. ValCheck:Attrs6=PICTURE="Picture":2:N
  459. ValCheck:Name=FIELDNUM
  460.  
  461. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  462. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  463. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  464.  
  465. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  466. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  467. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  468. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  469. Reference:Name=NAME
  470. Reference:OnAfterLoad=GetReferenceInfo
  471.  
  472. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  473. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  474.  
  475. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  476. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  477. Security:Name=PASSWORD
  478.  
  479. [ODBC Properties]
  480. DriverType:Values=Closed,PARADOX="Paradox",DBASE="dBase",FOXPRO="FoxPro"
  481. BooleanYN:Values=Closed,0="No",-1="Yes",1="Yes"
  482. FieldVChecks:Values=Closed,0=,1="Has Validity Checks",2=
  483. FieldRights:Values=Closed,0="Read/Write",1="Read Only",2="None",3=
  484. LookupType:Values1=Closed,0="None",1="Current Field",2="All Corresponding"
  485. LookupType:Values2=3="Current Field & Help",4="All Corresponding & Help"
  486. ReferenceType:Values=Closed,0="Master Of",1="Detail Of"
  487. ReferenceQual:Values=Closed,0="Restrict",1="Cascade"
  488. PrivilegeType:Values1=Closed,0="None",1="Read Only",3="Modify/Read",7="Insert/Modify/Read"
  489. PrivilegeType:Values2=15="Delete/Insert/Modify/Read",31="All Rights",255=
  490. FamilyRightsType:Values=Closed,0="None",1="Form",2="Reports",4="Validity Checks",8="Settings"
  491.  
  492. ODBC:Objects1=O:C:0M::"Tables":Table
  493. ODBC:Objects2=O:C:0M::"Procedures":Procedure
  494.  
  495. Table:Dataset1=NAME=String:261,FILENAME=String:261,EXTENSION=String:4,TYPE=String:32
  496. Table:Dataset2=DATE=Date,TIME=Time,SIZE=Integer,VIEW=Word,SYNONYM=Word
  497. Table:Dataset3=STRUCTURE=String:32,VERSION=Word,RECORDSIZE=Word,FIELDS=Word
  498. Table:Dataset4=INDEXES=Word,VALCHECKS=Word,REFCHECKS=Word,RECORDS=Integer
  499. Table:Dataset5=PROTECTED=Word,VALID=Word
  500.  
  501. Table:Category=Dataset
  502. Table:Attrs1=TYPE="Type"::NR:::VM=DriverType
  503. Table:Attrs2=DATE="Date"
  504. Table:Attrs3=TIME="Time"
  505. Table:Attrs4=VERSION="Version":2
  506. Table:Attrs5=VALID="Valid":2::::VM=BooleanYN
  507. Table:Attrs6=STRUCTURE="Structure":2
  508. Table:Attrs7=PROTECTED="Protected":2::::VM=BooleanYN
  509. Table:Name=FILENAME,EXTENSION
  510. Table:Objects1=O:P:1M::"Fields":Column
  511. Table:Objects2=O:O:0M::"Indices":Index
  512. Table:Objects3=O:O:0M::"Validity Checks":ValCheck
  513. Table:Objects4=O:O:0M::"Referential Constraints":Reference
  514. Table:Objects5=O:O:0M::"Security Specs":Security
  515.  
  516. Column:Dataset1=FIELDNUM=Word,NAME=String:32,TYPE=Word,SUBTYPE=Word
  517. Column:Dataset2=UNITS1=SmallInt,UNITS2=SmallInt,OFFSET=Word,LENGTH=Word
  518. Column:Dataset3=NULLOFFSET=Word,VCheck=Word,Rights=Word,CALCFIELD=Boolean
  519.  
  520. Column:Category=Column
  521. Column:Order=FIELDNUM
  522. Column:Attrs1=FIELDNUM="Order":2:NR
  523. Column:Attrs2=TYPE="Type":1:NR
  524. Column:Attrs3=UNITS1="Size":1:N
  525. Column:Attrs4=UNITS2="Scale":1:N
  526. Column:Attrs5=LENGTH="Physical Length"
  527. Column:Name=NAME
  528.  
  529. Index:Dataset1=NAME=String:261,INDEXID=Word,TAGNAME=String:32,FORMAT=String:32
  530. Index:Dataset2=PRIMARY=Boolean,UNIQUE=Boolean,DESCENDING=Boolean,AUTO=Boolean
  531. Index:Dataset3=SUBSET=Boolean,KEYISEXP=Boolean,COST=Word,FIELDS=Word,KEYLEN=Word
  532. Index:Dataset4=OUTOFDATE=Boolean,EXPTYPE=Word,FIELDARRAY=Bytes:32
  533. Index:Dataset5=EXPRESSION=String:221,CONDITION=String:221,CASEINSENSITIVE=Boolean
  534. Index:Dataset6=BLOCKSIZE=Word,RESTRNUM=Word,DESCENDINGARRAY=Bytes:32
  535.  
  536. Index:Category=Index
  537. Index:Attrs1=NAME=Name:0,TAGNAME=Tag:0,RESTRNUM="Version":2
  538. Index:Attrs2=PRIMARY="Primary Key":::::VM=BooleanYN
  539. Index:Attrs3=UNIQUE="Unique"::NR:::VM=BooleanYN
  540. Index:Attrs4=AUTO="Maintained":2::::VM=BooleanYN
  541. Index:Attrs5=OUTOFDATE="Out of Date":2::::VM=BooleanYN
  542. Index:Attrs6=FORMAT="Format":2
  543. Index:Attrs7=BLOCKSIZE="Block Size":2
  544. Index:Attrs8=CASEINSENSITIVE="Case Insensitive":2:NR:::VM=BooleanYN
  545. Index:Attrs9=DESCENDING="Descending":2:NR:::VM=BooleanYN
  546. Index:Attrs10=EXPRESSION="Expression":2:N
  547. Index:Attrs11=CONDITION="Subset Condition":2:N
  548. Index:Name=NAME
  549. Index:OnAfterLoad=GetIndexInfo
  550.  
  551. ValCheck:Dataset1=FIELDNUM=Word,REQUIRED=Boolean,HASMINVAL=Boolean
  552. ValCheck:Dataset2=HASMAXVAL=Boolean,HASDEFVAL=Boolean,MINVALUE=String:256
  553. ValCheck:Dataset3=MAXVALUE=String:256,DEFAULT=String:256,PICTURE=String:176
  554. ValCheck:Dataset4=LOOKUPTYPE=Integer,LOOKUPTABLE=String:261
  555.  
  556. ValCheck:Attrs1=FIELDNUM="Field":2:NR
  557. ValCheck:Attrs2=REQUIRED="Required":1:NR:::VM=BooleanYN
  558. ValCheck:Attrs3=MINVALUE="Min Value":1:N
  559. ValCheck:Attrs4=MAXVALUE="Max Value":1:N
  560. ValCheck:Attrs5=DEFAULT="Default Value":1:N
  561. ValCheck:Attrs6=PICTURE="Picture":2:N
  562. ValCheck:Name=FIELDNUM
  563.  
  564. Reference:Dataset1=REFINTNUM=Word,NAME=String:32,TYPE=Integer
  565. Reference:Dataset2=OTHERTABLE=String:261,MODOP=Integer,DELOP=Integer
  566. Reference:Dataset3=FIELDCOUNT=Word,FIELDARRAY=Bytes:32,OTHERFIELDARRAY=Bytes:32
  567.  
  568. Reference:Attrs1=TYPE="Reference Type":1::::VM=ReferenceType
  569. Reference:Attrs2=OTHERTABLE="Reference To":1:NR
  570. Reference:Attrs3=MODOP="Modify Operation":1:NR:::VM=ReferenceQual
  571. Reference:Attrs4=DELOP="Delete Operation":1:NR:::VM=ReferenceQual
  572. Reference:Name=NAME
  573. Reference:OnAfterLoad=GetReferenceInfo
  574.  
  575. Security:Dataset1=ID=Word,TYPE=Integer,FAMRIGHTS=Word,PASSWORD=String:32
  576. Security:Dataset2=FIELDPRVARRAY=Bytes:1020
  577.  
  578. Security:Attrs1=TYPE="Table Rights":1:NR:::VM=PrivilegeType
  579. Security:Attrs2=FAMRIGHTS="Family Rights":1:NR:::VS=FamilyRightsType:$0F
  580. Security:Name=PASSWORD
  581.  
  582. Procedure:Dataset=NAME=String,DATE=Date,TIME=Time
  583.  
  584. Procedure:Category=Executable
  585. Procedure:Attrs=DATE="Date":1,TIME="Time":1
  586. Procedure:EAttrs=Data
  587. Procedure:Name=NAME
  588.  
  589.  
  590.  
  591. [ORACLE Properties]
  592. TBooleanNY:Values=Closed,N="No",Y="Yes"
  593. TBlank0:Values=Open,0=
  594. TValid:Values=Closed,INVALID=:"No",VALID=:"Yes"
  595. TDisabled:Values=Closed,ENABLED=ENABLE:"No",DISABLED=DISABLE:"Yes"
  596. TDataType:Values1=Open,CHAR=`'CHAR('=Length')'`:CHAR
  597. TDataType:Values2=DATE=DATE
  598. TDataType:Values3=FLOAT=FLOAT
  599. TDataType:Values4=LONG=LONG
  600. TDataType:Values5=LONG RAW=LONG RAW
  601. TDataType:Values6=MLSLABEL=MLSLABEL
  602. TDataType:Values7=NUMBER=NUMBER
  603. TDataType:Values8=RAW=`'RAW('=Length')'`:RAW
  604. TDataType:Values9=ROWID=ROWID
  605. TDataType:Values10=VARCHAR2=`'VARCHAR2('=Length')'`:VARCHAR2
  606. TUnique:Values=Closed,NONUNIQUE=:"No",UNIQUE=UNIQUE:"Yes"
  607. TNulls:Values=Closed,N=NOT NULL:"No",Y=:"Yes"
  608. TBeforeAfter:Values=Closed,0=BEFORE:"Before",-1=AFTER:"After"
  609. TRowStatement:Values1=Closed,STATEMENT=:"For each statement"
  610. TRowStatement:Values2=ROW=FOR EACH ROW:"For each row"
  611. TMaxValue:Values=Open,=`'MAXVALUE ' @MaxValue`:`:MaxValue`,1E+27=NOMAXVALUE:"None"
  612. TMinValue:Values=Open,=`'MINVALUE ' @MinValue`:`:MinValue`,1E+27=NOMINVALUE:"None"
  613. TCycle:Values=Closed,N=NOCYCLE:"No",Y=CYCLE:"Yes"
  614. TOrder:Values=Closed,N=NOORDER:"No",Y=ORDER:"Yes"
  615. TCache:Values=Open,=`'CACHE ' @Cache`:`:Cache`,0=NOCACHE:"None"
  616. TTSStatus:Values1=Closed,ONLINE=ONLINE:"Online",OFFLINE=OFFLINE:"Offline"
  617. TTSStatus:Values2=READ ONLY=:"Read Only",INVALID=:"Invalid"
  618. TCluster:Values=Closed,INDEX=INDEX:"Index",HASH=HASH:"Hash"
  619. THashFn:Values1=Closed,COLUMN=:"Column",DEFAULT=:"Default",HASH EXPRESSION=:"Expression"
  620. THashFn:Values2=DEFAULT2=:"Default2"
  621. TRefresh:Values=Closed,FAST=FAST:"Fast",COMPLETE=COMPLETE:"Complete",FORCE=FORCE:"Force"
  622.  
  623. Template:Storage1=`! \N '    INITIAL ' =INITIAL_EXTENT`
  624. Template:Storage2=`! \N '    NEXT ' =NEXT_EXTENT`
  625. Template:Storage3=`! \N '    MINEXTENTS ' =MIN_EXTENTS`
  626. Template:Storage4=`! \N '    MAXEXTENTS ' =MAX_EXTENTS`
  627. Template:Storage5=`! \N '    PCTINCREASE ' =PCT_INCREASE`
  628.  
  629. Template:ObjectStorage=`ETemplates Storage`
  630.  
  631. ORACLE:UserName=select user from dual
  632. ORACLE:Comments=--;/*,*/
  633.  
  634. ORACLE:Objects1=O:C:0M::"Tables":Table
  635. ORACLE:Objects2=O:C:0M::"Views":View
  636. ORACLE:Objects3=O:C:0M::"Synonyms":Synonym
  637. ORACLE:Objects4=O:C:0M::"Snapshots":Snapshot
  638. ORACLE:Objects5=O:C:0M::"Clusters":Cluster
  639. ORACLE:Objects6=O:C:0M::"TableSpaces":TableSpace
  640. ORACLE:Objects7=O:C:0M::"Sequences":Sequence
  641. ORACLE:Objects8=O:C:0M::"Procedures":Procedure
  642. ORACLE:Objects9=O:C:0M::"Functions":Function
  643. ORACLE:Objects10=O:C:0M::"Packages":Package
  644. ORACLE:Objects11=O:C:0M::"Package Bodies":PackageBody
  645.  
  646. SYS.ALL_OBJECTS:Name=OWNER,OBJECT_NAME
  647. SYS.ALL_OBJECTS:Attrs1=STATUS="Valid":::::VM=TValid
  648. SYS.ALL_OBJECTS:Attrs2=CREATED="Created"
  649. SYS.ALL_OBJECTS:Attrs3=LAST_DDL_TIME="Modified"
  650. SYS.ALL_OBJECTS:FilterSystemObjects=A.OWNER <> 'SYS'
  651.  
  652. SYS.ALL_TABLES:Name=OWNER,TABLE_NAME
  653. SYS.ALL_TABLES:Objects1=T:P:1M::"Columns":Column
  654. SYS.ALL_TABLES:Objects2=T:O:0M::"Indices":Index
  655. SYS.ALL_TABLES:Objects3=T:O:01::"Primary Key":PrimaryKey
  656. SYS.ALL_TABLES:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  657. SYS.ALL_TABLES:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  658. SYS.ALL_TABLES:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  659. SYS.ALL_TABLES:Objects7=T:O:0M::"Triggers":Trigger
  660. SYS.ALL_TABLES:Objects8=P:R:M1::"TableSpace":TableSpace
  661. SYS.ALL_TABLES:Objects9=P:R:M1::"Cluster":Cluster
  662. SYS.ALL_TABLES:Attrs1=BACKED_UP="Backed Up":::::VM=TBooleanNY
  663. SYS.ALL_TABLES:Attrs2=PCT_FREE="Block Min % Free":2:E
  664. SYS.ALL_TABLES:Attrs3=PCT_USED="Block Min % Used":2:E
  665. SYS.ALL_TABLES:Attrs4=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  666. SYS.ALL_TABLES:Attrs5=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  667. SYS.ALL_TABLES:Attrs6=INITIAL_EXTENT="Initial Extent (B)":2:E
  668. SYS.ALL_TABLES:Attrs7=NEXT_EXTENT="Next Extent (B)":2:E
  669. SYS.ALL_TABLES:Attrs8=MIN_EXTENTS="Min Extents":2:E
  670. SYS.ALL_TABLES:Attrs9=MAX_EXTENTS="Max Extents":2:E
  671. SYS.ALL_TABLES:Attrs10=PCT_INCREASE="Extent Size % Increase":2:E
  672. SYS.ALL_TABLES:Attrs11=NUM_ROWS="Row Count":2
  673. SYS.ALL_TABLES:Attrs12=CHAIN_CNT="Chained Rows":2
  674. SYS.ALL_TABLES:Attrs13=BLOCKS="Data Block Count":2
  675. SYS.ALL_TABLES:Attrs14=EMPTY_BLOCKS="Empty Data Blocks":2
  676. SYS.ALL_TABLES:Attrs15=AVG_SPACE="Avg Bytes Free / Block":2
  677. SYS.ALL_TABLES:Attrs16=AVG_ROW_LEN="Avg Row Length":2
  678. SYS.ALL_TABLES:Reference:"TableSpace"=TABLESPACE_NAME
  679. SYS.ALL_TABLES:Reference:"Cluster"=CLUSTER_NAME
  680. SYS.ALL_TABLES:FilterSystemObjects=A.OWNER <> 'SYS'
  681.  
  682. SYS.ALL_SYNONYMS:Name=OWNER,SYNONYM_NAME
  683. SYS.ALL_SYNONYMS:Attrs1=TABLE_OWNER="Target Owner"::E
  684. SYS.ALL_SYNONYMS:Attrs2=TABLE_NAME="Target Object"::ER
  685. SYS.ALL_SYNONYMS:Attrs3=DB_LINK="Database"::E
  686. SYS.ALL_SYNONYMS:Reference:"Target"=TABLE_OWNER,TABLE_NAME
  687.  
  688. SYS.ALL_SNAPSHOTS:Name=OWNER,NAME
  689. SYS.ALL_SNAPSHOTS:Objects=P:R:M1::"Snapshot Table":Table
  690. SYS.ALL_SNAPSHOTS:Attrs1=TYPE="Refresh Type"::E:::VM=TRefresh
  691. ; !!! First Refresh::E
  692. SYS.ALL_SNAPSHOTS:Attrs2=START_WITH="First Refresh"
  693. SYS.ALL_SNAPSHOTS:Attrs3=NEXT="Next Refresh"::E
  694. SYS.ALL_SNAPSHOTS:Attrs4=QUERY="Snapshot Query":2:ER
  695. SYS.ALL_SNAPSHOTS:Attrs5=ERROR="Error"
  696. SYS.ALL_SNAPSHOTS:Attrs6=LAST_REFRESH="Last Refresh"
  697. SYS.ALL_SNAPSHOTS:Attrs7=MASTER_LINK="Master Database":2
  698. SYS.ALL_SNAPSHOTS:Attrs8=MASTER_OWNER="Master Owner":2
  699. SYS.ALL_SNAPSHOTS:Attrs9=MASTER_VIEW="Master View":2
  700. SYS.ALL_SNAPSHOTS:Attrs10=MASTER="Master Table":2
  701. SYS.ALL_SNAPSHOTS:Attrs11=UPDATABLE="Updatable":2
  702. SYS.ALL_SNAPSHOTS:Attrs12=CAN_USE_LOG="Snapshot Log":2
  703. SYS.ALL_SNAPSHOTS:Reference:"Snapshot Table"=OWNER,TABLE_NAME
  704.  
  705. SYS.ALL_INDEXES:Key=TABLE_OWNER,TABLE_NAME,OWNER,INDEX_NAME
  706. SYS.ALL_INDEXES:Name=OWNER,INDEX_NAME
  707. SYS.ALL_INDEXES:Objects1=T:P:1M::"Columns":IndexColumn
  708. SYS.ALL_INDEXES:Objects2=P:R:M1::"TableSpace":TableSpace
  709. SYS.ALL_INDEXES:Attrs1=STATUS="Valid":::::VM=TValid
  710. SYS.ALL_INDEXES:Attrs2=UNIQUENESS="Unique"::E:::VM=TUnique
  711. SYS.ALL_INDEXES:Attrs3=INITIAL_EXTENT="Initial Extent (B)":2:E
  712. SYS.ALL_INDEXES:Attrs4=NEXT_EXTENT="Other Extents (B)":2:E
  713. SYS.ALL_INDEXES:Attrs5=MIN_EXTENTS="Minimum Extents":2:E
  714. SYS.ALL_INDEXES:Attrs6=MAX_EXTENTS="Maximum Extents":2:E
  715. SYS.ALL_INDEXES:Attrs7=PCT_INCREASE="% Increase":2:E
  716. SYS.ALL_INDEXES:Attrs8=PCT_FREE="Minimum % Free":2:E
  717. SYS.ALL_INDEXES:Attrs9=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  718. SYS.ALL_INDEXES:Attrs10=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  719. SYS.ALL_INDEXES:Reference:"TableSpace"=TABLESPACE_NAME
  720.  
  721. SYS.ALL_IND_COLUMNS:Key=TABLE_OWNER,TABLE_NAME,INDEX_OWNER,INDEX_NAME,COLUMN_NAME
  722. SYS.ALL_IND_COLUMNS:Name=Column
  723. SYS.ALL_IND_COLUMNS:Order=COLUMN_POSITION
  724. SYS.ALL_IND_COLUMNS:Objects1=P:R:M1::"Column":Column:<<>Column
  725. SYS.ALL_IND_COLUMNS:Attrs1=COLUMN_POSITION="Order":2:ER
  726. SYS.ALL_IND_COLUMNS:Reference:"Column"=TABLE_OWNER,TABLE_NAME,COLUMN_NAME
  727. ; !!! ASC/DESC information is lost in system catalog
  728.  
  729. SYS.ALL_TAB_COLUMNS:Key=OWNER,TABLE_NAME,COLUMN_NAME
  730. SYS.ALL_TAB_COLUMNS:Name=COLUMN_NAME
  731. SYS.ALL_TAB_COLUMNS:Order=COLUMN_ID
  732. SYS.ALL_TAB_COLUMNS:Attrs1=COLUMN_ID="Order":2:ER
  733. SYS.ALL_TAB_COLUMNS:Attrs2=DATA_TYPE=Type="Type"::ER:::VM=TDataType
  734. SYS.ALL_TAB_COLUMNS:Attrs3=DATA_LENGTH=Length="Length"::E
  735. SYS.ALL_TAB_COLUMNS:Attrs4=DATA_PRECISION=Precision="Precision"::E
  736. SYS.ALL_TAB_COLUMNS:Attrs5=DATA_SCALE=Scale="Scale"::E
  737. SYS.ALL_TAB_COLUMNS:Attrs6=NULLABLE=Null="Nulls"::E:::VM=TNulls
  738. SYS.ALL_TAB_COLUMNS:Attrs7=DATA_DEFAULT=Default="Default":2:E
  739.  
  740. SYS.ALL_SEQUENCES:Name=SEQUENCE_OWNER,SEQUENCE_NAME
  741. SYS.ALL_SEQUENCES:Attrs1=LAST_NUMBER="Last Value"::E
  742. SYS.ALL_SEQUENCES:Attrs2=INCREMENT_BY="Increment By"::E
  743. SYS.ALL_SEQUENCES:Attrs3=CYCLE_FLAG=Cycle="Cycle"::E:::VM=TCycle
  744. SYS.ALL_SEQUENCES:Attrs4=ORDER_FLAG=Order="In Order"::E:::VM=TOrder
  745. SYS.ALL_SEQUENCES:Attrs5=MIN_VALUE=MinValue="Minimum Value":2:E:::VM=TMinValue
  746. SYS.ALL_SEQUENCES:Attrs6=MAX_VALUE=MaxValue="Maximum Value":2:E:::VM=TMaxValue
  747. SYS.ALL_SEQUENCES:Attrs7=CACHE_SIZE=Cache="Cache Size":2:E:::VM=TCache
  748.  
  749. SYS.ALL_TRIGGERS:Key=TABLE_OWNER,TABLE_NAME,OWNER,TRIGGER_NAME
  750. SYS.ALL_TRIGGERS:Name=OWNER,TRIGGER_NAME
  751. SYS.ALL_TRIGGERS:Attrs1=TRIGGERING_EVENT="Events"::ER
  752. SYS.ALL_TRIGGERS:Attrs2=TRIGGER_TYPE="Type"::E:::VM=TRowStatement
  753. SYS.ALL_TRIGGERS:Attrs3=REFERENCING_NAMES="Referencing Names":0:E
  754. SYS.ALL_TRIGGERS:Attrs4=WHEN_CLAUSE="When":2:E::PStripWhen
  755. SYS.ALL_TRIGGERS:Attrs5=DESCRIPTION="Description":0
  756. SYS.ALL_TRIGGERS:Attrs6=TRIGGER_BODY="Text":3:ER
  757. ; !!! Fix REFERENCING_NAMES
  758.  
  759. SYS.ALL_CONSTRAINTS:Key=OWNER,TABLE_NAME,CONSTRAINT_NAME
  760. SYS.ALL_CONSTRAINTS:Name=CONSTRAINT_NAME
  761. SYS.ALL_CONSTRAINTS:Attrs1=STATUS="Disabled"::E:::VM=TDisabled
  762.  
  763. SYS.ALL_CONS_COLUMNS:Key=OWNER,TABLE_NAME,CONSTRAINT_NAME,COLUMN_NAME
  764. SYS.ALL_CONS_COLUMNS:Name=Column
  765. SYS.ALL_CONS_COLUMNS:Order=POSITION
  766. SYS.ALL_CONS_COLUMNS:Objects1=P:R:M1::"Column":Column:<<>Column
  767. SYS.ALL_CONS_COLUMNS:Attrs1=POSITION="Order":2:ER
  768. SYS.ALL_CONS_COLUMNS:Reference:"Column"=OWNER,TABLE_NAME,COLUMN_NAME
  769.  
  770. SYS.SYSFILES:Key=TSNAME,FNAME
  771. SYS.SYSFILES:Name=FNAME
  772. SYS.SYSFILES:Attrs=FNAME=:3,BLOCKS="Blocks"
  773.  
  774. SYS.USER_CLUSTERS:Name=CLUSTER_NAME
  775. SYS.USER_CLUSTERS:Objects1=T:P:1M::"Columns":ClusterColumn
  776. SYS.USER_CLUSTERS:Objects2=P:R:M1::"TableSpace":TableSpace
  777. SYS.USER_CLUSTERS:Attrs1=CLUSTER_TYPE="Type":::::VM=TCluster
  778. SYS.USER_CLUSTERS:Attrs2=FUNCTION="Hash Fn":::::VM=THashFn
  779. SYS.USER_CLUSTERS:Attrs3=PCT_FREE="Block Min % Free":2
  780. SYS.USER_CLUSTERS:Attrs4=PCT_USED="Block Min % Used":2
  781. SYS.USER_CLUSTERS:Attrs5=INI_TRANS="Initial Transactions":2::::VM=TBlank0
  782. SYS.USER_CLUSTERS:Attrs6=MAX_TRANS="Maximum Transactions":2::::VM=TBlank0
  783. SYS.USER_CLUSTERS:Attrs7=INITIAL_EXTENT="Initial Extent (B)":2
  784. SYS.USER_CLUSTERS:Attrs8=NEXT_EXTENT="Other Extents (B)":2
  785. SYS.USER_CLUSTERS:Attrs9=MIN_EXTENTS="Minimum Extents":2
  786. SYS.USER_CLUSTERS:Attrs10=MAX_EXTENTS="Maximum Extents":2
  787. SYS.USER_CLUSTERS:Attrs11=PCT_INCREASE="Extent Size % Increase":2
  788. SYS.USER_CLUSTERS:Attrs12=KEY_SIZE="Key Size":2
  789. SYS.USER_CLUSTERS:Attrs13=HASHKEYS="Hash Keys":2
  790. SYS.USER_CLUSTERS:Attrs14=AVG_BLOCKS_PER_KEY="Blocks / Key":2
  791. SYS.USER_CLUSTERS:Reference:"TableSpace"=TABLESPACE_NAME
  792.  
  793. SYS.USER_CLU_COLUMNS:Key=CLUSTER_NAME,CLU_COLUMN_NAME
  794. SYS.USER_CLU_COLUMNS:Name=CLU_COLUMN_NAME
  795. SYS.USER_CLU_COLUMNS:Attrs1=TABLE_NAME="Table"
  796. SYS.USER_CLU_COLUMNS:Attrs2=TAB_COLUMN_NAME="Column"
  797.  
  798. SYS.USER_TABLESPACES:Name=TABLESPACE_NAME
  799. SYS.USER_TABLESPACES:Attrs1=STATUS="Status":::::VM=TTSStatus
  800. SYS.USER_TABLESPACES:Attrs2=INITIAL_EXTENT="Initial Extent (B)":2:E
  801. SYS.USER_TABLESPACES:Attrs3=NEXT_EXTENT="Other Extents (B)":2:E
  802. SYS.USER_TABLESPACES:Attrs4=MIN_EXTENTS="Minimum Extents":2:E
  803. SYS.USER_TABLESPACES:Attrs5=MAX_EXTENTS="Maximum Extents":2:E
  804. SYS.USER_TABLESPACES:Attrs6=PCT_INCREASE="% Increase":2:E
  805.  
  806. CheckConstraint:Definition=Root=SYS.ALL_CONSTRAINTS
  807. CheckConstraint:Category=Expression
  808. CheckConstraint:Values=A.CONSTRAINT_TYPE = 'C'
  809. CheckConstraint:Attrs1=SEARCH_CONDITION=Text="Constraint Text":2:ER
  810. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  811. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  812. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N` `\N`  CHECK (`=Text`)
  813. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  814. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  815. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  816.  
  817. Cluster:Definition=Root=SYS.USER_CLUSTERS
  818. Cluster:EAttrs=
  819.  
  820. ClusterColumn:Definition=Root=SYS.USER_CLU_COLUMNS
  821. ClusterColumn:EAttrs=
  822.  
  823. Column:Definition=Root=SYS.ALL_TAB_COLUMNS
  824. Column:Category=Column
  825. Column:EAttrs=Text,New,Delete,Modify,Rename
  826. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  827.  
  828. KeyColumn:Definition=Root=SYS.ALL_CONS_COLUMNS
  829. KeyColumn:Category=ColumnReference
  830. KeyColumn:Attrs:R=Column:::2:ER
  831. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  832. KeyColumn:Text:Get=`N`
  833.  
  834. ForeignKey:Definition=Root=SYS.ALL_CONSTRAINTS
  835. ForeignKey:Category=ForeignKey
  836. ForeignKey:Values=A.CONSTRAINT_TYPE = 'R'
  837. ForeignKey:Objects1=T:P:1M::"Columns":KeyColumn
  838. ForeignKey:Objects2=P:R:M1::"Reference Table":Table
  839. ForeignKey:Attrs=DELETE_RULE="Delete Rule":2
  840. ; !!! Fix Attrs:T self-joins and convert Q to T
  841. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  842. ForeignKey:Attrs:R=Table::::ER
  843. ForeignKey:AttrReference:ReferenceTable1=SELECT TABLE_NAME FROM SYS.ALL_CONSTRAINTS
  844. ForeignKey:AttrReference:ReferenceTable2=WHERE CONSTRAINT_TYPE IN ('P', 'U')
  845. ForeignKey:AttrReference:ReferenceTable3=AND OWNER=`:R_OWNER`
  846. ForeignKey:AttrReference:ReferenceTable4=AND CONSTRAINT_NAME=`:R_CONSTRAINT_NAME`
  847. ForeignKey:Reference:"Reference Table"=R_OWNER,ReferenceTable
  848. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  849. ForeignKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `N`
  850. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [KeyColumn:%s, %s:N] ')'`
  851. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  852. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  853.  
  854. Parameter:Definition=Root=SYS.ALL_TAB_COLUMNS
  855. Parameter:Category=Column
  856. Parameter:EAttrs=Text
  857. Parameter:Text:Get=`N`
  858.  
  859. Function:Definition=Root=SYS.ALL_OBJECTS
  860. Function:Category=Executable
  861. Function:Values=A.OBJECT_TYPE = 'FUNCTION'
  862. Function:Objects=T:P:0M::"Parameters":Parameter
  863. Function:Attrs:Q=Text=Memo::"Text"::ER
  864. Function:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  865. Function:AttrReference:Text2=where OWNER=`OQ0` and NAME=`OQ1`
  866. Function:AttrReference:Text3=order by LINE
  867. Function:Warning=Loss
  868. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  869. Function:Text:Get=CREATE `=Text`
  870. Function:Text:Init1=CREATE FUNCTION `EDefaultName`
  871. Function:Text:Init2=RETURN datatype AS `\N`BEGIN`\N`END;
  872. Function:Text:NameRE=Text:FUNCTION\_(\_*\w+)
  873. Function:Text:NameSet=1=`N`
  874. Function:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(FUNCTION\_+(\w+)\_.*)
  875. Function:Text:Set=1=`''`,Text=2,*N=3
  876. Function:Modify:RE=(CREATE)\_+FUNCTION
  877. Function:Modify:Set=1=`'CREATE OR REPLACE'`
  878. Function:Delete:Text=DROP FUNCTION `O`
  879. Function:Actions="Compile"
  880. Function:"Compile":Text=ALTER FUNCTION `N` COMPILE
  881.  
  882. Index:Definition=Root=SYS.ALL_INDEXES
  883. Index:Category=Index
  884. Index:Attrs:R=TableSpace::INITIAL_EXTENT:2:E
  885. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  886. Index:Text:Get1=CREATE `=UNIQUENESS` INDEX `N`
  887. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:N]`)
  888. Index:Text:Get3=`! \N '  TABLESPACE ' =TableSpace`
  889. Index:Text:Get4=`! \N '  PCTFREE ' =PCT_FREE`
  890. Index:Text:Get5=`! \N '  INITRANS ' =INI_TRANS`
  891. Index:Text:Get6=`! \N '  MAXTRANS ' =MAX_TRANS`
  892. Index:Text:Get7=`! \N '  STORAGE (' ETemplates ObjectStorage ')'`
  893. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  894. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  895. Index:Delete:Text=DROP INDEX `O`
  896.  
  897. IndexColumn:Definition=Root=SYS.ALL_IND_COLUMNS
  898. IndexColumn:Category=ColumnReference
  899. IndexColumn:Attrs:R=Column:::2:ER
  900. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  901. IndexColumn:Text:Get=`N`
  902.  
  903. Package:Definition=Root=SYS.ALL_OBJECTS
  904. Package:Values=A.OBJECT_TYPE = 'PACKAGE'
  905. Package:Objects=P:R:M0::"Package Body":PackageBody
  906. Package:Attrs:Q=Text=Memo::"Text"::ER
  907. Package:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  908. Package:AttrReference:Text2=where OWNER=`OQ0` and NAME=`OQ1`
  909. Package:AttrReference:Text3=and TYPE=`:OBJECT_TYPE` order by LINE
  910. Package:Warning=Loss
  911. Package:EAttrs=Text,New,Delete,Modify,Rename,Save
  912. Package:Text:Get=CREATE `=Text`
  913. Package:Text:Init=CREATE PACKAGE `EDefaultName` AS`\N`END;
  914. Package:Text:NameRE=Text:PACKAGE\_(\_*\w+)
  915. Package:Text:NameSet=1=`N`
  916. Package:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PACKAGE\_+(\w+)\_.*)
  917. Package:Text:Set=1=`''`,Text=2,*N=3
  918. Package:Modify:RE=(CREATE)\_+PACKAGE
  919. Package:Modify:Set=1=`'CREATE OR REPLACE'`
  920. Package:Delete:Text=DROP PACKAGE `O`
  921. Package:Actions="Compile","Compile All":';'
  922. Package:"Compile All":Text1=ALTER PACKAGE `N` COMPILE PACKAGE;
  923. Package:"Compile All":Text2=ALTER PACKAGE `N` COMPILE BODY
  924. Package:"Compile":Text=ALTER PACKAGE `N` COMPILE PACKAGE
  925.  
  926. PackageBody:Definition=Root=SYS.ALL_OBJECTS
  927. PackageBody:Values=A.OBJECT_TYPE = 'PACKAGE BODY'
  928. PackageBody:Objects=P:R:M0::"Package":Package
  929. PackageBody:Attrs:Q=Text=Memo::"Text"::ER
  930. PackageBody:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  931. PackageBody:AttrReference:Text2=where OWNER=`OQ0` and NAME=`OQ1`
  932. PackageBody:AttrReference:Text3=and TYPE=`:OBJECT_TYPE` order by LINE
  933. PackageBody:Warning=Loss
  934. PackageBody:EAttrs=Text,New,Delete,Modify,Rename,Save
  935. PackageBody:Text:Get=CREATE `=Text`
  936. PackageBody:Text:Init=CREATE PACKAGE BODY `EDefaultName` AS`\N`END;
  937. PackageBody:Text:NameRE=Text:PACKAGE\_+BODY\_(\_*\w+)
  938. PackageBody:Text:NameSet=1=`N`
  939. PackageBody:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PACKAGE\_+BODY\_+(\w+)\_.*)
  940. PackageBody:Text:Set=1=`''`,Text=2,*N=3
  941. PackageBody:Modify:RE=(CREATE)\_+PACKAGE\_+BODY
  942. PackageBody:Modify:Set=1=`'CREATE OR REPLACE'`
  943. PackageBody:Delete:Text=DROP PACKAGE BODY `O`
  944. PackageBody:Actions="Compile"
  945. PackageBody:"Compile":Text=ALTER PACKAGE `N` COMPILE BODY
  946.  
  947. PrimaryKey:Definition=Root=SYS.ALL_CONSTRAINTS
  948. PrimaryKey:Category=PrimaryKey
  949. PrimaryKey:Values=A.CONSTRAINT_TYPE = 'P'
  950. PrimaryKey:Objects=T:P:1M::"Columns":KeyColumn
  951. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  952. PrimaryKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `N`
  953. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [KeyColumn:%s, %s:N] ')'`
  954. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  955.  
  956. Procedure:Definition=Root=SYS.ALL_OBJECTS
  957. Procedure:Category=Executable
  958. Procedure:Values=A.OBJECT_TYPE = 'PROCEDURE'
  959. Procedure:Objects=T:P:0M::"Parameters":Parameter
  960. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  961. Procedure:AttrReference:Text1=select TEXT from SYS.ALL_SOURCE
  962. Procedure:AttrReference:Text2=where OWNER=`OQ0` and NAME=`OQ1`
  963. Procedure:AttrReference:Text3=order by LINE
  964. Procedure:Warning=Loss
  965. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  966. Procedure:Text:Get=CREATE `=Text`
  967. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS `\N`BEGIN`\N`END;
  968. Procedure:Text:NameRE=Text:PROCEDURE\_(\_*\w+)
  969. Procedure:Text:NameSet=1=`N`
  970. Procedure:Text:RE=CREATE\_+(OR\_+REPLACE\_+)?(PROCEDURE\_+(\w+)\_.*)
  971. Procedure:Text:Set=1=`''`,Text=2,*N=3
  972. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  973. Procedure:Modify:Set=1=`'CREATE OR REPLACE'`
  974. Procedure:Delete:Text=DROP PROCEDURE `O`
  975. Procedure:Actions="Compile"
  976. Procedure:"Compile":Text=ALTER PROCEDURE `N` COMPILE
  977.  
  978. Sequence:Definition=Root=SYS.ALL_SEQUENCES
  979. Sequence:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::LAST_NUMBER
  980. Sequence:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::LAST_NUMBER
  981. Sequence:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::LAST_NUMBER
  982. Sequence:Warning=Loss
  983. Sequence:EAttrs=Text,New,Delete,Modify,Rename,Save
  984. Sequence:Text:Get1=CREATE SEQUENCE `N`
  985. Sequence:Text:Get2=`! \N '  START WITH ' =LAST_NUMBER`
  986. Sequence:Text:Get3=`! \N '  INCREMENT BY ' =INCREMENT_BY`
  987. Sequence:Text:Get4=`! \N '  ' =MaxValue`
  988. Sequence:Text:Get5=`! \N '  ' =MinValue`
  989. Sequence:Text:Get6=`! \N '  ' =Cycle`
  990. Sequence:Text:Get7=`! \N '  ' =Cache`
  991. Sequence:Text:Get8=`! \N '  ' =Order`
  992. Sequence:Delete:Text=DROP SEQUENCE `O`
  993.  
  994. Snapshot:Definition=Root=SYS.ALL_SNAPSHOTS
  995. Snapshot:Warning=DataLoss
  996. Snapshot:EAttrs=Text,New,Delete,Modify,Rename,Save
  997. Snapshot:Text:Get1=CREATE SNAPSHOT `N \N` `! ' REFRESH ' =TYPE \N`
  998. ; Snapshot:Text:Get1.5=`! ' START WITH ' =START_WITH \N`
  999. Snapshot:Text:Get2=`! ' NEXT ' =NEXT \N` AS `=QUERY`
  1000. Snapshot:Delete:Text=DROP SNAPSHOT `O`
  1001. Snapshot:OnAfterLoad=SnapshotLoaded
  1002.  
  1003. Synonym:Definition=Root=SYS.ALL_SYNONYMS
  1004. Synonym:Category=Dataset
  1005. Synonym:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::TABLE_OWNER
  1006. Synonym:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::TABLE_OWNER
  1007. Synonym:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::TABLE_OWNER
  1008. Synonym:Warning=Loss
  1009. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1010. Synonym:Text:Init=CREATE SYNONYM `EDefaultName \N`FOR "owner"."object"
  1011. Synonym:Text:Get1=CREATE `ESynonymName N \N`FOR "`=TABLE_OWNER`"."`=TABLE_NAME`"
  1012. Synonym:Delete:Text=DROP `ESynonymName O`
  1013.  
  1014. Table:Definition=Root=SYS.ALL_TABLES
  1015. Table:Category=Dataset
  1016. Table:Attrs:T1=SYS.ALL_OBJECTS.STATUS=::BACKED_UP
  1017. Table:Attrs:T2=SYS.ALL_OBJECTS.CREATED=::BACKED_UP
  1018. Table:Attrs:T3=SYS.ALL_OBJECTS.LAST_DDL_TIME=::BACKED_UP
  1019. Table:Attrs:R1=TableSpace::PCT_FREE:2:E
  1020. Table:Attrs:R2=Cluster::PCT_FREE:2:E
  1021. Table:Warning=DataLoss
  1022. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1023. Table:Text:Get1=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  1024. Table:Text:Get2=`! \N '  TABLESPACE ' =TableSpace`
  1025. Table:Text:Get3=`! \N '  PCTFREE ' =PCT_FREE`
  1026. Table:Text:Get4=`! \N '  PCTUSED ' =PCT_USED`
  1027. Table:Text:Get5=`! \N '  INITRANS ' =INI_TRANS`
  1028. Table:Text:Get6=`! \N '  MAXTRANS ' =MAX_TRANS`
  1029. Table:Text:Get7=`! \N '  STORAGE (' ETemplates ObjectStorage ')'`
  1030. Table:Rename:Text=RENAME "`O1`" TO "`N1`"
  1031. Table:Delete:Text=DROP TABLE `O`
  1032.  
  1033. Trigger:Definition=Root=SYS.ALL_TRIGGERS
  1034. Trigger:Category=Executable
  1035. Trigger:Attrs:P=WhenEvent=Boolean::"Event Time":1:ER:::VM=TBeforeAfter
  1036. Trigger:Attrs:R=WhenEvent::"Event"
  1037. Trigger:OnAfterLoad=TriggerLoaded
  1038. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  1039. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName`
  1040. Trigger:Text:Init2=AFTER INSERT OR DELETE OR UPDATE`\N`
  1041. Trigger:Text:Init3=ON `{<}N \N`
  1042. Trigger:Text:Init4=FOR EACH ROW`\N`
  1043. Trigger:Text:Init5=BEGIN`\N`END;
  1044. Trigger:Text:Get1=CREATE TRIGGER `N ' ' =WhenEvent ' ' =TRIGGERING_EVENT`
  1045. Trigger:Text:Get2=`\N`ON `{<}N``! \N =TRIGGER_TYPE`
  1046. Trigger:Text:Get3=`! \N 'WHEN (' =WHEN_CLAUSE ')'`` \N =TRIGGER_BODY`
  1047. Trigger:Text:RE1=CREATE\_+(OR\_+REPLACE\_+)?TRIGGER\_+(\w+)\_+(\w+)\_+(.*)\_ON
  1048. Trigger:Text:RE2=(\_*\w+)\_*(FOR EACH ROW)?\_*(WHEN\_*\(.*\)\_+)?(BEGIN\_.*)
  1049. Trigger:Text:Set1=1=`''`,*N=2,WhenEvent=3,-TRIGGERING_EVENT=4,5=`{<}N`
  1050. Trigger:Text:Set2=TRIGGER_TYPE=6,WHEN_CLAUSE=7,TRIGGER_BODY=8
  1051. Trigger:Modify:RE=(CREATE)\_+TRIGGER
  1052. Trigger:Modify:Set=1=`'CREATE OR REPLACE'`
  1053. Trigger:Delete:Text=DROP TRIGGER `O`
  1054.  
  1055. UniqueConstraint:Definition=Root=SYS.ALL_CONSTRAINTS
  1056. UniqueConstraint:Category=UniqueConstraint
  1057. UniqueConstraint:Values=A.CONSTRAINT_TYPE = 'U'
  1058. UniqueConstraint:Objects=T:P:1M::"Columns":KeyColumn
  1059. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1060. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  1061. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [KeyColumn:%s, %s:N] ')'`
  1062. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1063.  
  1064. View:Definition=Root=SYS.ALL_OBJECTS
  1065. View:Category=Dataset
  1066. View:Values=A.OBJECT_TYPE = 'VIEW'
  1067. View:Objects=T:P:0M:NMDR:"Columns":Column
  1068. View:Attrs:Q=Text=Memo::"Text"::ER
  1069. View:AttrReference:Text1=select TEXT from SYS.ALL_VIEWS
  1070. View:AttrReference:Text2=where OWNER=`OQ0` and VIEW_NAME=`OQ1`
  1071. View:Warning=Loss
  1072. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1073. View:Text:Init=CREATE VIEW `EDefaultName` AS `\N`  SELECT * FROM "owner"."object"
  1074. View:Text:Get=CREATE VIEW `N` AS `\N '  ' =Text`
  1075. View:Text:RE=CREATE\_+VIEW\_+(\w+)\_+AS\_+(.*)
  1076. View:Text:Set=Text=2,*N=1
  1077. View:Rename:Text=RENAME "`O1`" TO "`N1`"
  1078. View:Delete:Text=DROP VIEW `O`
  1079.  
  1080. TableSpace:Definition=Root=SYS.USER_TABLESPACES
  1081. TableSpace:Objects=T:C:1M::"Files":File
  1082. TableSpace:Reference:"Files":Text=`[File:%s,%s:\N '    ' \Q * \Q]`
  1083. TableSpace:Warning=Loss
  1084. TableSpace:EAttrs=Text
  1085. TableSpace:Text:Get1=CREATE TABLESPACE `N \N`
  1086. TableSpace:Text:Get2= DATAFILE `{>File}*\N`
  1087. TableSpace:Text:Get3=`! ' DEFAULT STORAGE (' ETemplates Storage ')' \N`
  1088. TableSpace:Text:Get9=`! ' ' =STATUS \N`
  1089. TableSpace:Delete:Text=DROP TABLESPACE `O`
  1090.  
  1091. File:Definition=Root=SYS.SYSFILES
  1092. File:Category=System
  1093. File:NameRE=.*
  1094. File:EAttrs=Text
  1095. File:Text:Get=`N`
  1096.  
  1097. [Oracle 7.2 Properties]
  1098.  
  1099. SYS.ALL_CLUSTERS:Name=OWNER,CLUSTER_NAME
  1100. SYS.ALL_CLUSTERS:Objects1=T:P:1M::"Columns":ClusterColumn
  1101. SYS.ALL_CLUSTERS:Objects1=P:R:M1::"TableSpace":TableSpace
  1102. SYS.ALL_CLUSTERS:Attrs1=CLUSTER_TYPE="Type":::::VM=TCluster
  1103. SYS.ALL_CLUSTERS:Attrs2=FUNCTION="Hash Fn":::::VM=THashFn
  1104. SYS.ALL_CLUSTERS:Attrs3=PCT_FREE="Block Min % Free":2
  1105. SYS.ALL_CLUSTERS:Attrs4=PCT_USED="Block Min % Used":2
  1106. SYS.ALL_CLUSTERS:Attrs5=INI_TRANS="Initial Transactions":2::::VM=TBlank0
  1107. SYS.ALL_CLUSTERS:Attrs6=MAX_TRANS="Maximum Transactions":2::::VM=TBlank0
  1108. SYS.ALL_CLUSTERS:Attrs7=INITIAL_EXTENT="Initial Extent (B)":2
  1109. SYS.ALL_CLUSTERS:Attrs8=NEXT_EXTENT="Other Extents (B)":2
  1110. SYS.ALL_CLUSTERS:Attrs9=MIN_EXTENTS="Minimum Extents":2
  1111. SYS.ALL_CLUSTERS:Attrs10=MAX_EXTENTS="Maximum Extents":2
  1112. SYS.ALL_CLUSTERS:Attrs11=PCT_INCREASE="Extent Size % Increase":2
  1113. SYS.ALL_CLUSTERS:Attrs12=KEY_SIZE="Key Size":2
  1114. SYS.ALL_CLUSTERS:Attrs13=HASHKEYS="Hash Keys":2
  1115. SYS.ALL_CLUSTERS:Attrs14=AVG_BLOCKS_PER_KEY="Blocks / Key":2
  1116. SYS.ALL_CLUSTERS:Reference:"ClusterColumn"=CLUSTER_NAME
  1117. SYS.ALL_CLUSTERS:Reference:"TableSpace"=TABLESPACE_NAME
  1118.  
  1119. ; Add FREELISTS and FREELIST_GROUPS for Oracle 7.2+
  1120.  
  1121. Template:ObjectStorage1=`ETemplates Storage`
  1122. Template:ObjectStorage2=`! \N '    FREELISTS ' =FREELISTS`
  1123. Template:ObjectStorage3=`! \N '    FREELIST GROUPS ' =FREELIST_GROUPS`
  1124.  
  1125. SYS.ALL_TABLES:Attrs1=BACKED_UP="Backed Up":::::VM=TBooleanNY
  1126. SYS.ALL_TABLES:Attrs2=PCT_FREE="Block Min % Free":2:E
  1127. SYS.ALL_TABLES:Attrs3=PCT_USED="Block Min % Used":2:E
  1128. SYS.ALL_TABLES:Attrs4=INI_TRANS="Initial Transactions":2:E:::VM=TBlank0
  1129. SYS.ALL_TABLES:Attrs5=MAX_TRANS="Maximum Transactions":2:E:::VM=TBlank0
  1130. SYS.ALL_TABLES:Attrs6=INITIAL_EXTENT="Initial Extent (B)":2:E
  1131. SYS.ALL_TABLES:Attrs7=NEXT_EXTENT="Next Extent (B)":2:E
  1132. SYS.ALL_TABLES:Attrs8=MIN_EXTENTS="Min Extents":2:E
  1133. SYS.ALL_TABLES:Attrs9=MAX_EXTENTS="Max Extents":2:E
  1134. SYS.ALL_TABLES:Attrs10=PCT_INCREASE="Extent Size % Increase":2:E
  1135. SYS.ALL_TABLES:Attrs11=FREELISTS="Free Lists":2:E
  1136. SYS.ALL_TABLES:Attrs12=FREELIST_GROUPS="Free List Groups":2:E
  1137. SYS.ALL_TABLES:Attrs13=NUM_ROWS="Row Count":2
  1138. SYS.ALL_TABLES:Attrs14=CHAIN_CNT="Chained Rows":2
  1139. SYS.ALL_TABLES:Attrs15=BLOCKS="Data Block Count":2
  1140. SYS.ALL_TABLES:Attrs16=EMPTY_BLOCKS="Empty Data Blocks":2
  1141. SYS.ALL_TABLES:Attrs17=AVG_SPACE="Avg Bytes Free / Block":2
  1142. SYS.ALL_TABLES:Attrs18=AVG_ROW_LEN="Avg Row Length":2
  1143.  
  1144. ; !!! Use ALL_CLUSTERS instead of USER_CLUSTERS for 7.2+
  1145. ; Need DBA_CLU_COLUMNS (or ALL_CLU_COLUMNS) owner to fully qualify
  1146. ; which is not defined in 7.2
  1147. ; Cluster:Definition=Root=SYS.ALL_CLUSTERS
  1148. ; SYS.ALL_TABLES:Reference:"Cluster"=OWNER,CLUSTER_NAME
  1149.  
  1150.  
  1151.  
  1152.  
  1153. [MSSQL Properties]
  1154. TBooleanYN:Values=Closed,0="No",-1="Yes"
  1155. TPhysicalType:Values1=Closed,34=image:"Image",35=text:"Text"
  1156. TPhysicalType:Values2=37=varbinary:"VarBinary"
  1157. TPhysicalType:Values3=38=int:"Int"
  1158. TPhysicalType:Values4=39=varchar:"VarChar"
  1159. TPhysicalType:Values5=45=binary:"Binary"
  1160. TPhysicalType:Values6=47=char:"Char"
  1161. TPhysicalType:Values7=48=tinyint:"TinyInt"
  1162. TPhysicalType:Values8=50=bit:"Bit"
  1163. TPhysicalType:Values9=52=smallint:"SmallInt"
  1164. TPhysicalType:Values10=55=decimal:"Decimal"
  1165. TPhysicalType:Values11=56=int:"Int"
  1166. TPhysicalType:Values12=58=smalldatetime:"SmallDateTime"
  1167. TPhysicalType:Values13=59=real:"Real"
  1168. TPhysicalType:Values14=60=money:"Money"
  1169. TPhysicalType:Values15=61=datetime:"DateTime"
  1170. TPhysicalType:Values16=62=float:"Float"
  1171. TPhysicalType:Values17=63=numeric:"Numeric"
  1172. TPhysicalType:Values18=106=decimal:"Decimal"
  1173. TPhysicalType:Values19=108=numeric:"Numeric"
  1174. TPhysicalType:Values20=109=float:"Float"
  1175. TPhysicalType:Values21=110=money:"Money"
  1176. TPhysicalType:Values22=111=datetime:"DateTime"
  1177. TPhysicalType:Values23=122=smallmoney:"SmallMoney"
  1178. TNull01:Values=Closed,0=not null:"No",-1=null:"Yes"
  1179. TObjectType:Values1=Closed,S="System Table",U="Table",V="View",L="Log",P="Procedure",
  1180. TObjectType:Values2=R="Rule",D="Default",TR="Trigger",RI="Referential Constraint"
  1181. TObjectStatus:Values=Closed,256="Read Only",4096="RamboIX"
  1182. TColumnStatus:Values=Closed,8=NULL:"Null"
  1183. TIndexStatus:Values1=Closed,2=UNIQUE:"Unique",16=CLUSTERED:"Clustered"
  1184. TIndexStatus:Values2=1=:"Dup Key Abort",4=:"Dup Row Abort"
  1185. TIndexStatus:Values3=64=:"Allow Dup Rows",32768=:"Suspect"
  1186. TLoginStatus:Values=Closed,1=:"Small Password",2=:"Locked account",4=:"Password Expired"
  1187. TDeviceType:Values1=Closed,0=0:"Database",2=2:"Disk Dump",3=3:"Tape Dump",4=4:"Tape Dump"
  1188. TDeviceType:Values2=5=5:"Tape Dump",6=6:"Tape Dump",7=7:"Tape Dump",8=8:"Tape Dump"
  1189. TDeviceStatus:Values1=Closed,1=:"Default",2=:"Physical Disk",4=:"Logical Disk"
  1190. TDeviceStatus:Values2=8=:"Skip Header",16=:"Dump Device",32=:"Serial Writes"
  1191. TDeviceStatus:Values3=64=:"Device Mirrored",128=:"Reads Mirrored"
  1192. TDeviceStatus:Values4=256=:"Half-Mirrored",512=:"Mirror Enabled"
  1193. TSegmentStatus:Values=Closed,1=:"Default"
  1194.  
  1195. MSSQL:UserName=select user_name()
  1196. MSSQL:Comments=--;/*,*/
  1197.  
  1198. MSSQL:Objects1=O:C:0M::"Data Types":Type
  1199. MSSQL:Objects2=O:C:0M::"Tables":Table
  1200. MSSQL:Objects3=O:C:0M::"Views":View
  1201. MSSQL:Objects4=O:C:0M::"Procedures":Procedure
  1202. MSSQL:Objects5=O:C:0M::"Defaults":Default
  1203. MSSQL:Objects6=O:C:0M::"Rules":Rule
  1204. MSSQL:Objects7=O:C:0M::"Logins":Login
  1205. MSSQL:Objects8=O:C:0M::"Groups":Group
  1206. MSSQL:Objects9=O:C:0M::"Users":User
  1207. MSSQL:Objects10=O:C:0M::"Segments":Segment
  1208. MSSQL:Objects11=O:C:0M::"Devices":Device
  1209.  
  1210. dbo.sysobjects:Key=id
  1211. dbo.sysobjects:Name=Owner,name
  1212. dbo.sysobjects:Attrs1=crdate="Creation Date"
  1213. dbo.sysobjects:Attrs2=sysstat="Status":::::VS=TObjectStatus:$1100
  1214. ; dbo.sysobjects:FilterSystemObjects=user_name(A.uid) <> 'dbo'
  1215. ; Allow defaults, etc to have dbo name
  1216.  
  1217. dbo.syscolumns:Key=id,colid
  1218. dbo.syscolumns:Name=name
  1219. dbo.syscolumns:Order=colid
  1220. dbo.syscolumns:Objects1=P:R:M1::"Type":Type
  1221. dbo.syscolumns:Objects2=P:R:M1::"Default Value":Default
  1222. dbo.syscolumns:Objects3=P:R:M1::"Domain Rule":Rule
  1223. dbo.syscolumns:Reference:"Type"=usertype
  1224. dbo.syscolumns:Reference:"Default Value"=cdefault
  1225. dbo.syscolumns:Reference:"Domain Rule"=domain
  1226. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1227. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1228. dbo.syscolumns:Attrs3=status="Status"::E:::VS=TColumnStatus:$8
  1229.  
  1230. dbo.sysindexes:Key=id,indid
  1231. dbo.sysindexes:Name=name
  1232. dbo.sysindexes:Objects=Q:P:1M::"Columns":IndexColumn
  1233. dbo.sysindexes:Attrs1=status="Status":::::VS=TIndexStatus:$F77F
  1234. dbo.sysindexes:Attrs2=indid="Index Id":2
  1235. dbo.sysindexes:Attrs3=rowpage="Rows per page":2
  1236. dbo.sysindexes:Attrs4=minlen="Minimum row size":2
  1237. dbo.sysindexes:Attrs5=maxlen="Maximum row size":2
  1238.  
  1239. dbo.systypes:Key=usertype
  1240. dbo.systypes:Name=name
  1241. dbo.systypes:Objects1=P:R:M1::"Default Value":Default
  1242. dbo.systypes:Objects2=P:R:M1::"Domain Rule":Rule
  1243. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1244. dbo.systypes:Attrs2=length=Length="Length"::E
  1245. dbo.systypes:Attrs3=allownulls=Null="Nulls"::E:::VM=TNull01
  1246. dbo.systypes:Attrs4=variable="Variable Length":::::VM=TBooleanYN
  1247. dbo.systypes:Reference:"Default Value"=tdefault
  1248. dbo.systypes:Reference:"Domain Rule"=domain
  1249.  
  1250. dbo.syssegments:Key=segment
  1251. dbo.syssegments:Name=name
  1252. dbo.syssegments:Attrs1=status="Status":::::VS=TSegmentStatus:$FFFF
  1253.  
  1254. dbo.sysusers:Key=uid
  1255. dbo.sysusers:Name=name
  1256.  
  1257. master.dbo.syslogins:Dataset1=suid,status,accdate,totcpu,totio,spacelimit
  1258. master.dbo.syslogins:Dataset2=timelimit,resultlimit,dbname,name,language
  1259. master.dbo.syslogins:Key=suid
  1260. master.dbo.syslogins:Name=name
  1261. master.dbo.syslogins:Attrs1=dbname="Default Database"
  1262. master.dbo.syslogins:Attrs2=accdate="Last Access"
  1263. master.dbo.syslogins:Attrs3=status="Status":::::VS=TLoginStatus:$FFF7
  1264. master.dbo.syslogins:Attrs4=language="Default Language"
  1265. master.dbo.syslogins:Attrs5=totcpu="Total CPU":2
  1266. master.dbo.syslogins:Attrs6=totio="Total IO":2
  1267.  
  1268. master.dbo.sysdevices:Name=name
  1269. master.dbo.sysdevices:Attrs1=cntrltype="Type":::::VM=TDeviceType
  1270. master.dbo.sysdevices:Attrs2=status="Status":::::VS=TDeviceStatus:$FFFF
  1271. master.dbo.sysdevices:Attrs3=phyname="Physical Name"
  1272. master.dbo.sysdevices:Attrs4=mirrorname="Mirror Name"
  1273. master.dbo.sysdevices:Attrs5=low="First Page"
  1274. master.dbo.sysdevices:Attrs6=high="Last Page"
  1275.  
  1276. Table:Definition=Root=dbo.sysobjects
  1277. View:Definition=Root=dbo.sysobjects
  1278. Procedure:Definition=Root=dbo.sysobjects
  1279. Default:Definition=Root=dbo.sysobjects
  1280. Rule:Definition=Root=dbo.sysobjects
  1281. Trigger:Definition=Root=dbo.sysobjects
  1282. Type:Definition=Root=dbo.systypes
  1283. Index:Definition=Root=dbo.sysindexes
  1284. Column:Definition=Root=dbo.syscolumns
  1285. Parameter:Definition=Root=dbo.syscolumns
  1286. Segment:Definition=Root=dbo.syssegments
  1287. User:Definition=Root=dbo.sysusers
  1288. Group:Definition=Root=dbo.sysusers
  1289. Database:Definition=Root=master.dbo.sysdatabases
  1290. Login:Definition=Root=master.dbo.syslogins
  1291. Device:Definition=Root=master.dbo.sysdevices
  1292.  
  1293. Table:Category=Dataset
  1294. Table:Values=A.type IN ('U', 'S')
  1295. Table:Objects1=T:P:1M::"Columns":Column
  1296. Table:Objects2=T:O:0M::"Indices":Index
  1297. Table:Objects3=T:O:0M::"Triggers":Trigger
  1298. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *] \N`
  1299. Table:Reference:"Triggers"=id=deltrig
  1300. Table:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1301. Table:AttrReference:Owner=uid=uid
  1302. Table:FilterSystemObjects=A.type <> 'S'
  1303. Table:Warning=DataLoss
  1304. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1305. Table:Text:Get=CREATE TABLE `N` (`{>Column}*`)
  1306. Table:Delete:Text=DROP TABLE `O`
  1307. Table:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1308.  
  1309. View:Category=Dataset
  1310. View:Values=A.type = 'V'
  1311. View:Objects1=T:P:0M:NMDR:"Columns":Column
  1312. View:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1313. View:Attrs:Q=Text=String:255:"Text"::ER
  1314. View:AttrReference:Owner=uid=uid
  1315. View:AttrReference:Text1=select text from dbo.syscomments
  1316. View:AttrReference:Text2=where id=`:id` order by colid
  1317. View:Warning=Loss
  1318. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1319. View:Text:Init=CREATE VIEW `EDefaultName` AS `\N`  SELECT * FROM owner.object
  1320. View:Text:Get=`=Text`
  1321. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  1322. View:Text:NameSet=1=`N`
  1323. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  1324. View:Text:Set=Text=0,*N=2
  1325. View:Delete:Text=DROP VIEW `O`
  1326.  
  1327. Procedure:Category=Executable
  1328. Procedure:Values=A.type = 'P'
  1329. Procedure:Objects=T:P:0M::"Parameters":Parameter
  1330. Procedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1331. Procedure:Attrs:Q=Text=String:255:"Text"::ER
  1332. Procedure:AttrReference:Owner=uid=uid
  1333. Procedure:AttrReference:Text1=select text from dbo.syscomments
  1334. Procedure:AttrReference:Text2=where id=`:id` order by colid
  1335. Procedure:Warning=Loss
  1336. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1337. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS
  1338. Procedure:Text:Get=`=Text`
  1339. Procedure:Text:NameRE=Text:PROC(EDURE)?\_(\_*\w+)
  1340. Procedure:Text:NameSet=2=`N`
  1341. Procedure:Text:RE=^(.*\_)?CREATE\_+(PROC(EDURE)?)\_+(\w+)\_.*$
  1342. Procedure:Text:Set=2=`'PROCEDURE'`,Text=0,*N=4
  1343. Procedure:Delete:Text=DROP PROCEDURE `O`
  1344. Procedure:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1345.  
  1346. Default:Category=Expression
  1347. Default:Values=A.type = 'D'
  1348. Default:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1349. Default:Attrs:Q=Text=String:255:"Text":2:ER:PGetDefaultText
  1350. Default:AttrReference:Owner=uid=uid
  1351. Default:AttrReference:Text1=select text from dbo.syscomments
  1352. Default:AttrReference:Text2=where id=`:id` order by colid
  1353. Default:Warning=Loss
  1354. Default:EAttrs=Text,New,Delete,Modify,Rename,Save
  1355. Default:Text:Init=CREATE DEFAULT `EDefaultName` AS NULL
  1356. Default:Text:Get=CREATE DEFAULT `N` AS `=Text`
  1357. Default:Text:NameRE=Text:DEFAULT\_(\_*\w+)
  1358. Default:Text:NameSet=1=`N`
  1359. Default:Text:RE=CREATE\_+DEFAULT\_+(\w+)\_+AS\_(.*)
  1360. Default:Text:Set=*N=1,Text=2
  1361. Default:Delete:Text=DROP DEFAULT `O`
  1362.  
  1363. Rule:Category=Expression
  1364. Rule:Values=A.type = 'R'
  1365. Rule:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1366. Rule:Attrs:Q=Text=String:255:"Text"::ER
  1367. Rule:AttrReference:Owner=uid=uid
  1368. Rule:AttrReference:Text1=select text from dbo.syscomments
  1369. Rule:AttrReference:Text2=where id=`:id` order by colid
  1370. Rule:EAttrs=Text,New,Delete,Modify,Rename,Save
  1371. Rule:Text:Init=CREATE RULE `EDefaultName` AS NULL
  1372. Rule:Text:Get=`=Text`
  1373. Rule:Text:NameRE=Text:RULE\_+(\w+)
  1374. Rule:Text:NameSet=1=`N`
  1375. Rule:Text:RE=^(.*\_)?CREATE\_+RULE\_+(\w+)\_+.*$
  1376. Rule:Text:Set=*N=2,Text=0
  1377. Rule:Delete:Text=DROP RULE `O`
  1378.  
  1379. Trigger:Category=Executable
  1380. Trigger:Values=A.type = 'TR'
  1381. Trigger:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1382. Trigger:Attrs:Q=Text=String:255:"Text"::ER:PROOName
  1383. Trigger:AttrReference:Owner=uid=uid
  1384. Trigger:AttrReference:Text1=select text from dbo.syscomments
  1385. Trigger:AttrReference:Text2=where id=`:id` order by colid
  1386. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  1387. Trigger:Text:Init=CREATE TRIGGER `EDefaultName` ON `{<}N` FOR INSERT, UPDATE, DELETE AS`\N`
  1388. Trigger:Text:Get=`=Text`
  1389. Trigger:Text:NameRE=Text:TRIGGER\_+(\w+)\_+ON\_+(\w+)
  1390. Trigger:Text:NameSet=1=`N`,2=`{<}N`
  1391. Trigger:Text:RE=^(.*\_)?CREATE\_+TRIGGER\_+(\w+)\_+ON\_+(\w+).*$
  1392. Trigger:Text:Set=*N=2,3=`{<}N`,Text=0
  1393. Trigger:Delete:Text=DROP TRIGGER `O`
  1394.  
  1395. RIConstraint:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1396. RIConstraint:AttrReference:Owner=uid=uid
  1397.  
  1398. Column:Category=Column
  1399. Column:Attrs:R=Type:"Type":"Length":1:ER
  1400. Column:EAttrs=Text,New,Delete,Modify,Rename
  1401. Column:Text:Get=`N ' ' EType EDefault``! ' ' =status`
  1402.  
  1403. Index:Category=Index
  1404. Index:Values=A.keycnt > 0
  1405. Index:Attrs:R=status::::+E
  1406. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  1407. Index:Text:Get1=CREATE `=status` INDEX `N`
  1408. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:N]`)
  1409. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  1410. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  1411. Index:Delete:Text=DROP INDEX `{<}O`.`O`
  1412.  
  1413. IndexColumn:Category=ColumnReference
  1414. IndexColumn:Name=Column
  1415. IndexColumn:Order=Id
  1416. IndexColumn:Definition1=Dataset=
  1417. IndexColumn:Definition2=select Id=c.colid, TabId=c.id, ColId=i.colid
  1418. IndexColumn:Definition3=from sysindexes x, syscolumns c, syscolumns i
  1419. IndexColumn:Definition4=where (x.id=`:id`) and (x.id=c.id) and (x.id=i.id) and
  1420. IndexColumn:Definition5=(x.name=`OQ`) and (c.colid<=keycnt) and
  1421. IndexColumn:Definition6=(i.name=INDEX_COL(`{<}OQ`,x.indid,c.colid))
  1422. IndexColumn:Dataset=Id=Word,TabId=Word,ColId=Word
  1423. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1424. IndexColumn:Attrs1=Id="Order":2:ER
  1425. IndexColumn:Attrs:R=Column:::2:ER
  1426. IndexColumn:Reference:"Column"=TabId,ColId
  1427. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  1428. IndexColumn:Text:Get=`N`
  1429.  
  1430. Parameter:Category=Column
  1431. Parameter:Attrs:R=Type:"Type":"Length":1
  1432. Parameter:EAttrs=
  1433.  
  1434. Type:Category=Type
  1435. Type:Attrs:T=dbo.sysusers.name=Owner:"Owner":Type:1
  1436. Type:AttrReference:Owner=uid=uid
  1437. Type:Warning=Loss
  1438. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  1439. Type:Text:Init=sp_addtype "`EDefaultName`", "varchar(255)", "null"
  1440. Type:Text:Get=sp_addtype "`N`", "`EType`"`! ', "' =Null '"'`
  1441. Type:Delete:Text=sp_droptype "`O`"
  1442.  
  1443. Login:Attrs:P=Password=String
  1444. Login:Attrs:R=Password:"Password":"Default Language":2
  1445. Login:EAttrs=Text
  1446. Login:Text:Get=sp_addlogin "`N`", "`=Password`", "`=dbname`", "`=language`"
  1447. Login:Delete:Text=sp_droplogin "`O`"
  1448.  
  1449. Group:Values=A.uid = A.gid
  1450. ; !!! Group:Objects=P:R:0M::"Users":User
  1451. Group:Reference:"Users"=uid=gid
  1452. Group:EAttrs=Text
  1453. Group:Text:Get=sp_addgroup "`N`"
  1454. Group:Delete:Text=sp_dropgroup "`O`"
  1455.  
  1456. User:Values=A.uid <> A.gid
  1457. User:Objects1=P:R:M1::"Login":Login
  1458. User:Objects2=P:R:M1::"Group":Group
  1459. User:Reference:"Login"=suid
  1460. User:Reference:"Group"=gid
  1461. User:EAttrs=Text
  1462. User:Text:Get=sp_adduser "`=Login`", "`N`", "`=Group`"
  1463. User:Delete:Text=sp_dropuser "`O`"
  1464.  
  1465. Segment:Objects=P:R:M0::"Device":Device
  1466. Segment:Attrs:P=DeviceName=String:::0
  1467. Segment:Reference:"Device"=DeviceName
  1468. Segment:EAttrs=Text
  1469. Segment:Text:Get=sp_addsegment "`N`","`=Device`"
  1470. Segment:Delete:Text=sp_dropsegment "`O`"
  1471.  
  1472. Device:EAttrs=Text
  1473. Device:Text:Get1=DISK INIT NAME="`N`",`\N'  '`PHYSNAME="`=phyname`",
  1474. Device:Text:Get2=`\N'  '`VDEVNO=?,`\N'  '`SIZE=?,
  1475. Device:Text:Get3=`\N'  '`CNTRLTYPE=`=cntrltype`
  1476. Device:Delete:Text=sp_dropdevice "`O`"
  1477.  
  1478. [MSSQL 6 Properties]
  1479. MSSQL:Objects1=O:C:0M::"Data Types":Type
  1480. MSSQL:Objects2=O:C:0M::"Tables":Table
  1481. MSSQL:Objects3=O:C:0M::"Views":View
  1482. MSSQL:Objects4=O:C:0M::"Procedures":Procedure
  1483. MSSQL:Objects5=O:C:0M::"Extended Procedures":ExtendedProcedure
  1484. MSSQL:Objects6=O:C:0M::"Defaults":Default
  1485. MSSQL:Objects7=O:C:0M::"Rules":Rule
  1486. MSSQL:Objects8=O:C:0M::"Logins":Login
  1487. MSSQL:Objects9=O:C:0M::"Groups":Group
  1488. MSSQL:Objects10=O:C:0M::"Users":User
  1489. MSSQL:Objects11=O:C:0M::"Segments":Segment
  1490. MSSQL:Objects12=O:C:0M::"Devices":Device
  1491.  
  1492. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1493. dbo.systypes:Attrs2=length=Length="Length"::E
  1494. dbo.systypes:Attrs3=prec=Precision="Precision":2:E
  1495. dbo.systypes:Attrs4=scale=Scale="Scale":2:E
  1496. dbo.systypes:Attrs5=allownulls=Null="Nulls"::E:::VM=TNull01
  1497. dbo.systypes:Attrs6=variable="Variable Length":::::VM=TBooleanYN
  1498.  
  1499. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1500. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1501. dbo.syscolumns:Attrs3=prec=Precision="Precision":2:E
  1502. dbo.syscolumns:Attrs4=scale=Scale="Scale":2:E
  1503. dbo.syscolumns:Attrs5=status="Status"::E:::VS=TColumnStatus:$8
  1504.  
  1505. dbo.sysconstraints:Key=id,constid
  1506. dbo.sysconstraints:Name=name
  1507.  
  1508. dbo.sysreferences:Key=fkeyid,constid
  1509. dbo.sysreferences:Name=name
  1510.  
  1511. Table:Objects1=T:P:1M::"Columns":Column
  1512. Table:Objects2=T:O:0M::"Indices":Index
  1513. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  1514. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  1515. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  1516. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  1517. Table:Objects7=T:O:0M::"Triggers":Trigger
  1518.  
  1519. KeyColumn:Category=ColumnReference
  1520. KeyColumn:Definition=Dataset
  1521. KeyColumn:Dataset=ItemNo=Integer,ColNo=Integer
  1522. KeyColumn:Name=Column
  1523. KeyColumn:Order=ItemNo
  1524. KeyColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1525. KeyColumn:Attrs1=ItemNo="Order":2:ER
  1526. KeyColumn:Attrs:R=Column:::2:ER
  1527. KeyColumn:Reference:"Column"=,ColNo
  1528. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  1529. KeyColumn:Text:Get=`N`
  1530.  
  1531. PrimaryKey:Definition=Root=dbo.sysconstraints
  1532. PrimaryKey:Category=PrimaryKey
  1533. PrimaryKey:Values=A.status & 15 = 1
  1534. ; B.type = 'K'
  1535. PrimaryKey:Objects1=P:R:M1::"Index":Index:<>Index
  1536. PrimaryKey:Objects2=Q:P:1M::"Columns":IndexColumn
  1537. PrimaryKey:Attrs:T1=dbo.sysobjects.name=name:::0
  1538. PrimaryKey:Attrs:T2=dbo.sysobjects.crdate=crdate
  1539. PrimaryKey:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1540. PrimaryKey:Attrs:T4=dbo.sysindexes.indid=indid:::0
  1541. PrimaryKey:Reference:"Index"=,indid
  1542. PrimaryKey:Reference:"Columns":Text=`[IndexColumn:%s, %s:*]`
  1543. PrimaryKey:AttrReference:name=constid=id
  1544. PrimaryKey:AttrReference:crdate=constid=id
  1545. PrimaryKey:AttrReference:sysstat=constid=id
  1546. PrimaryKey:AttrReference:indid=B.name=name
  1547. ; and status & 0x1800 <> 0
  1548. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1549. PrimaryKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1550. PrimaryKey:Text:Init2= PRIMARY KEY (`{>IndexColumn}*`)
  1551. PrimaryKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1552. PrimaryKey:Text:Get2= PRIMARY KEY (`{>IndexColumn}*`)
  1553. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1554.  
  1555. ForeignKey:Definition=Root=dbo.sysreferences
  1556. ForeignKey:Category=ForeignKey
  1557. ; ForeignKey:Values=(B.status & 15 = 3) and (C.type = 'RI')
  1558. ForeignKey:Objects1=M:P:1M::"Columns":KeyColumn:GetKeyColumns
  1559. ForeignKey:Objects2=P:R:M1::"Reference Table":Table
  1560. ForeignKey:Attrs:T1=dbo.sysobjects.name=name:::0
  1561. ForeignKey:Attrs:T2=dbo.sysobjects.crdate=crdate
  1562. ForeignKey:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1563. ForeignKey:Attrs:R=Table::::ER
  1564. ForeignKey:Reference:"Columns":Text=`[KeyColumn:%s, %s:*]`
  1565. ForeignKey:Reference:"Reference Table"=rkeyid
  1566. ForeignKey:AttrReference:name=constid=id
  1567. ForeignKey:AttrReference:crdate=constid=id
  1568. ForeignKey:AttrReference:sysstat=constid=id
  1569. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1570. ForeignKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1571. ForeignKey:Text:Init2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  1572. ForeignKey:Text:Init3= REFERENCES `=Table`
  1573. ForeignKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1574. ForeignKey:Text:Get2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  1575. ForeignKey:Text:Get3= REFERENCES `=Table`
  1576. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1577.  
  1578. UniqueConstraint:Definition=Root=dbo.sysconstraints
  1579. UniqueConstraint:Category=UniqueConstraint
  1580. UniqueConstraint:Values=A.status & 15 = 2
  1581. ; B.type = 'K'
  1582. UniqueConstraint:Objects1=P:R:M1::"Index":Index:<>Index
  1583. UniqueConstraint:Objects2=Q:P:1M::"Columns":IndexColumn
  1584. UniqueConstraint:Attrs:T1=dbo.sysobjects.name=name:::0
  1585. UniqueConstraint:Attrs:T2=dbo.sysobjects.crdate=crdate
  1586. UniqueConstraint:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1587. UniqueConstraint:Attrs:T4=dbo.sysindexes.indid=indid:::0
  1588. UniqueConstraint:Reference:"Index"=,indid
  1589. UniqueConstraint:Reference:"Columns":Text=`[IndexColumn:%s, %s:*]`
  1590. UniqueConstraint:AttrReference:name=constid=id
  1591. UniqueConstraint:AttrReference:crdate=constid=id
  1592. UniqueConstraint:AttrReference:sysstat=constid=id
  1593. UniqueConstraint:AttrReference:indid=B.name=name
  1594. ; and status & 0x1800 <> 0
  1595. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1596. UniqueConstraint:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1597. UniqueConstraint:Text:Init2= UNIQUE (`{>IndexColumn}*`)
  1598. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1599. UniqueConstraint:Text:Get2= UNIQUE (`{>IndexColumn}*`)
  1600. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1601.  
  1602. CheckConstraint:Definition=Root=dbo.sysconstraints
  1603. CheckConstraint:Values=A.status & 15 = 4
  1604. ; B.type = 'C'
  1605. CheckConstraint:Category=Expression
  1606. CheckConstraint:Attrs:T1=dbo.sysobjects.name=name:::0
  1607. CheckConstraint:Attrs:T2=dbo.sysobjects.crdate=crdate
  1608. CheckConstraint:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1609. CheckConstraint:Attrs:Q=Text=String:255:"Constraint Text":2:ER:PStripParens
  1610. CheckConstraint:AttrReference:name=constid=id
  1611. CheckConstraint:AttrReference:crdate=constid=id
  1612. CheckConstraint:AttrReference:sysstat=constid=id
  1613. CheckConstraint:AttrReference:Text1=select text from dbo.syscomments
  1614. CheckConstraint:AttrReference:Text2=where id=`:constid` order by colid
  1615. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1616. CheckConstraint:Text:Init=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  1617. CheckConstraint:Text:Get=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`  CHECK (`=Text`)
  1618. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  1619. CheckConstraint:Text:Set=1=`{<}N`,*N=2,Text=3
  1620. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1621.  
  1622. ExtendedProcedure:Definition=Root=dbo.sysobjects
  1623. ExtendedProcedure:Category=Executable
  1624. ExtendedProcedure:Values=A.type = 'X'
  1625. ExtendedProcedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1626. ExtendedProcedure:Attrs:Q=DLLName=String:255:"DLL Name":2:ER
  1627. ExtendedProcedure:AttrReference:Owner=uid=uid
  1628. ExtendedProcedure:AttrReference:DLLName1=select text from dbo.syscomments
  1629. ExtendedProcedure:AttrReference:DLLName2=where id=`:id` order by colid
  1630. ExtendedProcedure:Warning=Loss
  1631. ExtendedProcedure:EAttrs=Text,New,Delete,Modify,Rename,Save
  1632. ExtendedProcedure:Text:Init=sp_addextendedproc '`EDefaultName`', 'dllname.dll'
  1633. ExtendedProcedure:Text:Get=sp_addextendedproc `NQ`, `:DLLName`
  1634. ExtendedProcedure:Text:RE=sp_addextendedproc\_+'(\w+)',\_+'(\w+)'
  1635. ExtendedProcedure:Text:Set=*N=1,DLLName=2
  1636. ExtendedProcedure:Delete:Text=sp_dropextendedproc `OQ`
  1637.  
  1638. [MSSQL 7 Properties]
  1639. MSSQL:Objects1=O:C:0M::"Data Types":Type
  1640. MSSQL:Objects2=O:C:0M::"Tables":Table
  1641. MSSQL:Objects3=O:C:0M::"Views":View
  1642. MSSQL:Objects4=O:C:0M::"Procedures":Procedure
  1643. MSSQL:Objects5=O:C:0M::"Extended Procedures":ExtendedProcedure
  1644. MSSQL:Objects6=O:C:0M::"Defaults":Default
  1645. MSSQL:Objects7=O:C:0M::"Rules":Rule
  1646. MSSQL:Objects8=O:C:0M::"Logins":Login
  1647. MSSQL:Objects9=O:C:0M::"Groups":Group
  1648. MSSQL:Objects10=O:C:0M::"Users":User
  1649.  
  1650. dbo.sysindexes:Key=id,indid
  1651. dbo.sysindexes:Name=name
  1652. dbo.sysindexes:Objects=Q:P:1M::"Columns":IndexColumn
  1653. dbo.sysindexes:Attrs1=status="Status":::::VS=TIndexStatus:$F77F
  1654. dbo.sysindexes:Attrs2=indid="Index Id":2
  1655. dbo.sysindexes:Attrs3=minlen="Minimum row size":2
  1656. dbo.sysindexes:Attrs4=maxlen="Maximum row size":2
  1657.  
  1658. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1659. dbo.systypes:Attrs2=length=Length="Length"::E
  1660. dbo.systypes:Attrs3=prec=Precision="Precision":2:E
  1661. dbo.systypes:Attrs4=scale=Scale="Scale":2:E
  1662. dbo.systypes:Attrs5=allownulls=Null="Nulls"::E:::VM=TNull01
  1663. dbo.systypes:Attrs6=variable="Variable Length":::::VM=TBooleanYN
  1664.  
  1665. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1666. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1667. dbo.syscolumns:Attrs3=prec=Precision="Precision":2:E
  1668. dbo.syscolumns:Attrs4=scale=Scale="Scale":2:E
  1669. dbo.syscolumns:Attrs5=status="Status"::E:::VS=TColumnStatus:$8
  1670.  
  1671. dbo.sysconstraints:Key=id,constid
  1672. dbo.sysconstraints:Name=name
  1673.  
  1674. dbo.sysreferences:Key=fkeyid,constid
  1675. dbo.sysreferences:Name=name
  1676.  
  1677. Table:Objects1=T:P:1M::"Columns":Column
  1678. Table:Objects2=T:O:0M::"Indices":Index
  1679. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  1680. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  1681. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  1682. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  1683. Table:Objects7=T:O:0M::"Triggers":Trigger
  1684.  
  1685. KeyColumn:Category=ColumnReference
  1686. KeyColumn:Definition=Dataset
  1687. KeyColumn:Dataset=ItemNo=Integer,ColNo=Integer
  1688. KeyColumn:Name=Column
  1689. KeyColumn:Order=ItemNo
  1690. KeyColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  1691. KeyColumn:Attrs1=ItemNo="Order":2:ER
  1692. KeyColumn:Attrs:R=Column:::2:ER
  1693. KeyColumn:Reference:"Column"=,ColNo
  1694. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  1695. KeyColumn:Text:Get=`N`
  1696.  
  1697. PrimaryKey:Definition=Root=dbo.sysconstraints
  1698. PrimaryKey:Category=PrimaryKey
  1699. PrimaryKey:Values=A.status & 15 = 1
  1700. ; B.type = 'K'
  1701. PrimaryKey:Objects1=P:R:M1::"Index":Index:<>Index
  1702. PrimaryKey:Objects2=Q:P:1M::"Columns":IndexColumn
  1703. PrimaryKey:Attrs:T1=dbo.sysobjects.name=name:::0
  1704. PrimaryKey:Attrs:T2=dbo.sysobjects.crdate=crdate
  1705. PrimaryKey:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1706. PrimaryKey:Attrs:T4=dbo.sysindexes.indid=indid:::0
  1707. PrimaryKey:Reference:"Index"=,indid
  1708. PrimaryKey:Reference:"Columns":Text=`[IndexColumn:%s, %s:*]`
  1709. PrimaryKey:AttrReference:name=constid=id
  1710. PrimaryKey:AttrReference:crdate=constid=id
  1711. PrimaryKey:AttrReference:sysstat=constid=id
  1712. PrimaryKey:AttrReference:indid=B.name=name
  1713. ; and status & 0x1800 <> 0
  1714. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1715. PrimaryKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1716. PrimaryKey:Text:Init2= PRIMARY KEY (`{>IndexColumn}*`)
  1717. PrimaryKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1718. PrimaryKey:Text:Get2= PRIMARY KEY (`{>IndexColumn}*`)
  1719. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1720.  
  1721. ForeignKey:Definition=Root=dbo.sysreferences
  1722. ForeignKey:Category=ForeignKey
  1723. ; ForeignKey:Values=(B.status & 15 = 3) and (C.type = 'RI')
  1724. ForeignKey:Objects1=M:P:1M::"Columns":KeyColumn:GetKeyColumns
  1725. ForeignKey:Objects2=P:R:M1::"Reference Table":Table
  1726. ForeignKey:Attrs:T1=dbo.sysobjects.name=name:::0
  1727. ForeignKey:Attrs:T2=dbo.sysobjects.crdate=crdate
  1728. ForeignKey:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1729. ForeignKey:Attrs:R=Table::::ER
  1730. ForeignKey:Reference:"Columns":Text=`[KeyColumn:%s, %s:*]`
  1731. ForeignKey:Reference:"Reference Table"=rkeyid
  1732. ForeignKey:AttrReference:name=constid=id
  1733. ForeignKey:AttrReference:crdate=constid=id
  1734. ForeignKey:AttrReference:sysstat=constid=id
  1735. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  1736. ForeignKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1737. ForeignKey:Text:Init2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  1738. ForeignKey:Text:Init3= REFERENCES `=Table`
  1739. ForeignKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1740. ForeignKey:Text:Get2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  1741. ForeignKey:Text:Get3= REFERENCES `=Table`
  1742. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1743.  
  1744. UniqueConstraint:Definition=Root=dbo.sysconstraints
  1745. UniqueConstraint:Category=UniqueConstraint
  1746. UniqueConstraint:Values=A.status & 15 = 2
  1747. ; B.type = 'K'
  1748. UniqueConstraint:Objects1=P:R:M1::"Index":Index:<>Index
  1749. UniqueConstraint:Objects2=Q:P:1M::"Columns":IndexColumn
  1750. UniqueConstraint:Attrs:T1=dbo.sysobjects.name=name:::0
  1751. UniqueConstraint:Attrs:T2=dbo.sysobjects.crdate=crdate
  1752. UniqueConstraint:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1753. UniqueConstraint:Attrs:T4=dbo.sysindexes.indid=indid:::0
  1754. UniqueConstraint:Reference:"Index"=,indid
  1755. UniqueConstraint:Reference:"Columns":Text=`[IndexColumn:%s, %s:*]`
  1756. UniqueConstraint:AttrReference:name=constid=id
  1757. UniqueConstraint:AttrReference:crdate=constid=id
  1758. UniqueConstraint:AttrReference:sysstat=constid=id
  1759. UniqueConstraint:AttrReference:indid=B.name=name
  1760. ; and status & 0x1800 <> 0
  1761. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1762. UniqueConstraint:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  1763. UniqueConstraint:Text:Init2= UNIQUE (`{>IndexColumn}*`)
  1764. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  1765. UniqueConstraint:Text:Get2= UNIQUE (`{>IndexColumn}*`)
  1766. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1767.  
  1768. CheckConstraint:Definition=Root=dbo.sysconstraints
  1769. CheckConstraint:Values=A.status & 15 = 4
  1770. ; B.type = 'C'
  1771. CheckConstraint:Category=Expression
  1772. CheckConstraint:Attrs:T1=dbo.sysobjects.name=name:::0
  1773. CheckConstraint:Attrs:T2=dbo.sysobjects.crdate=crdate
  1774. CheckConstraint:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  1775. CheckConstraint:Attrs:Q=Text=String:255:"Constraint Text":2:ER:PStripParens
  1776. CheckConstraint:AttrReference:name=constid=id
  1777. CheckConstraint:AttrReference:crdate=constid=id
  1778. CheckConstraint:AttrReference:sysstat=constid=id
  1779. CheckConstraint:AttrReference:Text1=select text from dbo.syscomments
  1780. CheckConstraint:AttrReference:Text2=where id=`:constid` order by colid
  1781. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  1782. CheckConstraint:Text:Init=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  1783. CheckConstraint:Text:Get=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`  CHECK (`=Text`)
  1784. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  1785. CheckConstraint:Text:Set=1=`{<}N`,*N=2,Text=3
  1786. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  1787.  
  1788. ExtendedProcedure:Definition=Root=dbo.sysobjects
  1789. ExtendedProcedure:Category=Executable
  1790. ExtendedProcedure:Values=A.type = 'X'
  1791. ExtendedProcedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1792. ExtendedProcedure:Attrs:Q=DLLName=String:255:"DLL Name":2:ER
  1793. ExtendedProcedure:AttrReference:Owner=uid=uid
  1794. ExtendedProcedure:AttrReference:DLLName1=select text from dbo.syscomments
  1795. ExtendedProcedure:AttrReference:DLLName2=where id=`:id` order by colid
  1796. ExtendedProcedure:Warning=Loss
  1797. ExtendedProcedure:EAttrs=Text,New,Delete,Modify,Rename,Save
  1798. ExtendedProcedure:Text:Init=sp_addextendedproc '`EDefaultName`', 'dllname.dll'
  1799. ExtendedProcedure:Text:Get=sp_addextendedproc `NQ`, `:DLLName`
  1800. ExtendedProcedure:Text:RE=sp_addextendedproc\_+'(\w+)',\_+'(\w+)'
  1801. ExtendedProcedure:Text:Set=*N=1,DLLName=2
  1802. ExtendedProcedure:Delete:Text=sp_dropextendedproc `OQ`
  1803.  
  1804.  
  1805.  
  1806. [SYBASE Properties]
  1807. TBooleanYN:Values=Closed,0="No",-1="Yes"
  1808. TPhysicalType:Values1=Closed,34=image:"Image",35=text:"Text"
  1809. TPhysicalType:Values2=37=varbinary:"VarBinary"
  1810. TPhysicalType:Values3=38=int:"Int"
  1811. TPhysicalType:Values4=39=varchar:"VarChar"
  1812. TPhysicalType:Values5=45=binary:"Binary"
  1813. TPhysicalType:Values6=47=char:"Char"
  1814. TPhysicalType:Values7=48=tinyint:"TinyInt"
  1815. TPhysicalType:Values8=50=bit:"Bit"
  1816. TPhysicalType:Values9=52=smallint:"SmallInt"
  1817. TPhysicalType:Values10=55=decimal:"Decimal"
  1818. TPhysicalType:Values11=56=int:"Int"
  1819. TPhysicalType:Values12=58=smalldatetime:"SmallDateTime"
  1820. TPhysicalType:Values13=59=real:"Real"
  1821. TPhysicalType:Values14=60=money:"Money"
  1822. TPhysicalType:Values15=61=datetime:"DateTime"
  1823. TPhysicalType:Values16=62=float:"Float"
  1824. TPhysicalType:Values17=63=numeric:"Numeric"
  1825. TPhysicalType:Values18=106=decimal:"Decimal"
  1826. TPhysicalType:Values19=108=numeric:"Numeric"
  1827. TPhysicalType:Values20=109=float:"Float"
  1828. TPhysicalType:Values21=110=money:"Money"
  1829. TPhysicalType:Values22=111=datetime:"DateTime"
  1830. TPhysicalType:Values23=122=smallmoney:"SmallMoney"
  1831. TNull01:Values=Closed,0=not null:"No",-1=null:"Yes"
  1832. TObjectType:Values1=Closed,S="System Table",U="Table",V="View",L="Log",P="Procedure",
  1833. TObjectType:Values2=R="Rule",D="Default",TR="Trigger",RI="Referential Constraint"
  1834. TObjectStatus:Values=Closed,256="Read Only",4096="RamboIX"
  1835. TColumnStatus:Values=Closed,8=NULL:"Null"
  1836. TIndexStatus:Values1=Closed,2=UNIQUE:"Unique",16=CLUSTERED:"Clustered"
  1837. TIndexStatus:Values2=1=:"Dup Key Abort",4=:"Dup Row Abort"
  1838. TIndexStatus:Values3=64=:"Allow Dup Rows",32768=:"Suspect"
  1839. TLoginStatus:Values=Closed,1=:"Small Password",2=:"Locked account",4=:"Password Expired"
  1840. TDeviceType:Values1=Closed,0=0:"Database",2=2:"Disk Dump",3=3:"Tape Dump",4=4:"Tape Dump"
  1841. TDeviceType:Values2=5=5:"Tape Dump",6=6:"Tape Dump",7=7:"Tape Dump",8=8:"Tape Dump"
  1842. TDeviceStatus:Values1=Closed,1=:"Default",2=:"Physical Disk",4=:"Logical Disk"
  1843. TDeviceStatus:Values2=8=:"Skip Header",16=:"Dump Device",32=:"Serial Writes"
  1844. TDeviceStatus:Values3=64=:"Device Mirrored",128=:"Reads Mirrored"
  1845. TDeviceStatus:Values4=256=:"Half-Mirrored",512=:"Mirror Enabled"
  1846. TSegmentStatus:Values=Closed,1=:"Default"
  1847.  
  1848. SYBASE:UserName=select user_name()
  1849. SYBASE:Comments=--;/*,*/
  1850.  
  1851. SYBASE:Objects1=O:C:0M::"Data Types":Type
  1852. SYBASE:Objects2=O:C:0M::"Tables":Table
  1853. SYBASE:Objects3=O:C:0M::"Views":View
  1854. SYBASE:Objects4=O:C:0M::"Procedures":Procedure
  1855. SYBASE:Objects5=O:C:0M::"Defaults":Default
  1856. SYBASE:Objects6=O:C:0M::"Rules":Rule
  1857. SYBASE:Objects7=O:C:0M::"Logins":Login
  1858. SYBASE:Objects8=O:C:0M::"Groups":Group
  1859. SYBASE:Objects9=O:C:0M::"Users":User
  1860. SYBASE:Objects10=O:C:0M::"Segments":Segment
  1861. SYBASE:Objects11=O:C:0M::"Devices":Device
  1862.  
  1863. dbo.sysobjects:Key=id
  1864. dbo.sysobjects:Name=Owner,name
  1865. dbo.sysobjects:Attrs1=crdate="Creation Date"
  1866. dbo.sysobjects:Attrs2=sysstat="Status":::::VS=TObjectStatus:$1100
  1867. dbo.sysobjects:FilterSystemObjects=user_name(A.uid) <> 'dbo'
  1868. dbo.sysobjects:Dataset1=name,id,uid,type,userstat,sysstat,indexdel,
  1869. dbo.sysobjects:Dataset2=crdate,expdate,deltrig,instrig,updtrig,seltrig
  1870.  
  1871. dbo.syscolumns:Key=id,colid
  1872. dbo.syscolumns:Name=name
  1873. dbo.syscolumns:Order=colid
  1874. dbo.syscolumns:Objects1=P:R:M1::"Type":Type
  1875. dbo.syscolumns:Objects2=P:R:M1::"Default Value":Default
  1876. dbo.syscolumns:Objects3=P:R:M1::"Domain Rule":Rule
  1877. dbo.syscolumns:Reference:"Type"=usertype
  1878. dbo.syscolumns:Reference:"Default Value"=cdefault
  1879. dbo.syscolumns:Reference:"Domain Rule"=domain
  1880. dbo.syscolumns:Attrs1=colid="Order":2:ER
  1881. dbo.syscolumns:Attrs2=length=Length="Length"::E
  1882. dbo.syscolumns:Attrs3=status="Status"::E:::VS=TColumnStatus:$8
  1883.  
  1884. dbo.sysindexes:Key=id,indid
  1885. dbo.sysindexes:Name=name
  1886. dbo.sysindexes:Objects=Q:P:1M::"Columns":IndexColumn
  1887. dbo.sysindexes:Reference:"Columns":Text=`[IndexColumn:%s, %s:*]`
  1888. dbo.sysindexes:Attrs1=status="Status":::::VS=TIndexStatus:$8077
  1889. dbo.sysindexes:Attrs2=minlen="Minimum row size":2
  1890. dbo.sysindexes:Attrs3=maxlen="Maximum row size":2
  1891.  
  1892. dbo.systypes:Key=usertype
  1893. dbo.systypes:Name=name
  1894. dbo.systypes:Objects1=P:R:M1::"Default Value":Default
  1895. dbo.systypes:Objects2=P:R:M1::"Domain Rule":Rule
  1896. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  1897. dbo.systypes:Attrs2=length=Length="Length"::E
  1898. dbo.systypes:Attrs3=allownulls=Null="Nulls"::E:::VM=TNull01
  1899. dbo.systypes:Attrs4=variable="Variable Length":::::VM=TBooleanYN
  1900. dbo.systypes:Reference:"Default Value"=tdefault
  1901. dbo.systypes:Reference:"Domain Rule"=domain
  1902.  
  1903. dbo.syssegments:Key=segment
  1904. dbo.syssegments:Name=name
  1905. dbo.syssegments:Attrs1=status="Status":::::VS=TSegmentStatus:$FFFF
  1906.  
  1907. dbo.sysusers:Key=uid
  1908. dbo.sysusers:Name=name
  1909.  
  1910. master.dbo.syslogins:Dataset1=suid,status,accdate,totcpu,totio,spacelimit
  1911. master.dbo.syslogins:Dataset2=timelimit,resultlimit,dbname,name,language
  1912. master.dbo.syslogins:Key=suid
  1913. master.dbo.syslogins:Name=name
  1914. master.dbo.syslogins:Attrs1=dbname="Default Database"
  1915. master.dbo.syslogins:Attrs2=accdate="Last Access"
  1916. master.dbo.syslogins:Attrs3=status="Status":::::VS=TLoginStatus:$FFF7
  1917. master.dbo.syslogins:Attrs4=language="Default Language"
  1918. master.dbo.syslogins:Attrs5=totcpu="Total CPU":2
  1919. master.dbo.syslogins:Attrs6=totio="Total IO":2
  1920.  
  1921. master.dbo.sysdevices:Name=name
  1922. master.dbo.sysdevices:Attrs1=cntrltype="Type":::::VM=TDeviceType
  1923. master.dbo.sysdevices:Attrs2=status="Status":::::VS=TDeviceStatus:$FFFF
  1924. master.dbo.sysdevices:Attrs3=phyname="Physical Name"
  1925. master.dbo.sysdevices:Attrs4=mirrorname="Mirror Name"
  1926. master.dbo.sysdevices:Attrs5=low="First Page"
  1927. master.dbo.sysdevices:Attrs6=high="Last Page"
  1928.  
  1929. Table:Definition=Root=dbo.sysobjects
  1930. View:Definition=Root=dbo.sysobjects
  1931. Procedure:Definition=Root=dbo.sysobjects
  1932. Default:Definition=Root=dbo.sysobjects
  1933. Rule:Definition=Root=dbo.sysobjects
  1934. Trigger:Definition=Root=dbo.sysobjects
  1935. Type:Definition=Root=dbo.systypes
  1936. Index:Definition=Root=dbo.sysindexes
  1937. Column:Definition=Root=dbo.syscolumns
  1938. Parameter:Definition=Root=dbo.syscolumns
  1939. Segment:Definition=Root=dbo.syssegments
  1940. User:Definition=Root=dbo.sysusers
  1941. Group:Definition=Root=dbo.sysusers
  1942. Database:Definition=Root=master.dbo.sysdatabases
  1943. Login:Definition=Root=master.dbo.syslogins
  1944. Device:Definition=Root=master.dbo.sysdevices
  1945.  
  1946. Table:Category=Dataset
  1947. Table:Values=A.type IN ('U', 'S')
  1948. Table:Objects1=T:P:1M::"Columns":Column
  1949. Table:Objects2=T:O:0M::"Indices":Index
  1950. Table:Objects3=T:O:0M::"Triggers":Trigger
  1951. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *] \N`
  1952. Table:Reference:"Triggers"=id=deltrig
  1953. Table:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1954. Table:AttrReference:Owner=uid=uid
  1955. Table:FilterSystemObjects=A.type <> 'S'
  1956. Table:Warning=DataLoss
  1957. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1958. Table:Text:Get=CREATE TABLE `N` (`{>Column}*`)
  1959. Table:Delete:Text=DROP TABLE `O`
  1960. Table:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1961.  
  1962. View:Category=Dataset
  1963. View:Values=A.type = 'V'
  1964. View:Objects1=T:P:0M:NMDR:"Columns":Column
  1965. View:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1966. View:Attrs:Q=Text=String:255:"Text"::ER
  1967. View:AttrReference:Owner=uid=uid
  1968. View:AttrReference:Text1=select text from dbo.syscomments
  1969. View:AttrReference:Text2=where id=`:id` order by colid
  1970. View:Warning=Loss
  1971. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1972. View:Text:Init=CREATE VIEW `EDefaultName` AS `\N`  SELECT * FROM owner.table
  1973. View:Text:Get=`=Text`
  1974. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  1975. View:Text:NameSet=1=`N`
  1976. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  1977. View:Text:Set=Text=0,*N=2
  1978. View:Delete:Text=DROP VIEW `O`
  1979.  
  1980. Procedure:Category=Executable
  1981. Procedure:Values=A.type = 'P'
  1982. Procedure:Objects=T:P:0M::"Parameters":Parameter
  1983. Procedure:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  1984. Procedure:Attrs:Q=Text=String:255:"Text"::ER
  1985. Procedure:AttrReference:Owner=uid=uid
  1986. Procedure:AttrReference:Text1=select text from dbo.syscomments
  1987. Procedure:AttrReference:Text2=where id=`:id` order by colid
  1988. Procedure:Warning=Loss
  1989. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  1990. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS
  1991. Procedure:Text:Get=`=Text`
  1992. Procedure:Text:NameRE=Text:PROC(EDURE)?\_(\_*\w+)
  1993. Procedure:Text:NameSet=2=`N`
  1994. Procedure:Text:RE=^(.*\_)?CREATE\_+(PROC(EDURE)?)\_+(\w+)\_.*$
  1995. Procedure:Text:Set=2=`'PROCEDURE'`,Text=0,*N=4
  1996. Procedure:Delete:Text=DROP PROCEDURE `O`
  1997. Procedure:Rename:Text=`ESetUser O0`  exec sp_rename '`O1`','`N1`'  `ESetUser`
  1998.  
  1999. Default:Category=Expression
  2000. Default:Values=A.type = 'D'
  2001. Default:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  2002. Default:Attrs:Q=Text=String:255:"Text":2:ER:PGetDefaultText
  2003. Default:AttrReference:Owner=uid=uid
  2004. Default:AttrReference:Text1=select text from dbo.syscomments
  2005. Default:AttrReference:Text2=where id=`:id` order by colid
  2006. Default:Warning=Loss
  2007. Default:EAttrs=Text,New,Delete,Modify,Rename,Save
  2008. Default:Text:Init=CREATE DEFAULT `EDefaultName` AS NULL
  2009. Default:Text:Get=CREATE DEFAULT `N` AS `=Text`
  2010. Default:Text:NameRE=Text:DEFAULT\_(\_*\w+)
  2011. Default:Text:NameSet=1=`N`
  2012. Default:Text:RE=CREATE\_+DEFAULT\_+(\w+)\_+AS\_(.*)
  2013. Default:Text:Set=*N=1,Text=2
  2014. Default:Delete:Text=DROP DEFAULT `O`
  2015.  
  2016. Rule:Category=Expression
  2017. Rule:Values=A.type = 'R'
  2018. Rule:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  2019. Rule:Attrs:Q=Text=String:255:"Text"::ER
  2020. Rule:AttrReference:Owner=uid=uid
  2021. Rule:AttrReference:Text1=select text from dbo.syscomments
  2022. Rule:AttrReference:Text2=where id=`:id` order by colid
  2023. Rule:EAttrs=Text,New,Delete,Modify,Rename,Save
  2024. Rule:Text:Init=CREATE RULE `EDefaultName` AS NULL
  2025. Rule:Text:Get=`=Text`
  2026. Rule:Text:NameRE=Text:RULE\_+(\w+)
  2027. Rule:Text:NameSet=1=`N`
  2028. Rule:Text:RE=^(.*\_)?CREATE\_+RULE\_+(\w+)\_+.*$
  2029. Rule:Text:Set=*N=2,Text=0
  2030. Rule:Delete:Text=DROP RULE `O`
  2031.  
  2032. Trigger:Category=Executable
  2033. Trigger:Values=A.type = 'TR'
  2034. Trigger:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  2035. Trigger:Attrs:Q=Text=String:255:"Text"::ER:PROOName
  2036. Trigger:AttrReference:Owner=uid=uid
  2037. Trigger:AttrReference:Text1=select text from dbo.syscomments
  2038. Trigger:AttrReference:Text2=where id=`:id` order by colid
  2039. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  2040. Trigger:Text:Init=CREATE TRIGGER `EDefaultName` ON `{<}N` FOR INSERT, UPDATE, DELETE AS`\N`
  2041. Trigger:Text:Get=`=Text`
  2042. Trigger:Text:NameRE=Text:TRIGGER\_+(\w+)\_+ON\_+(\w+)
  2043. Trigger:Text:NameSet=1=`N`,2=`{<}N`
  2044. Trigger:Text:RE=^(.*\_)?CREATE\_+TRIGGER\_+(\w+)\_+ON\_+(\w+).*$
  2045. Trigger:Text:Set=*N=2,3=`{<}N`,Text=0
  2046. Trigger:Delete:Text=DROP TRIGGER `O`
  2047.  
  2048. RIConstraint:Attrs:T=dbo.sysusers.name=Owner:"Owner":name:0
  2049. RIConstraint:AttrReference:Owner=uid=uid
  2050.  
  2051. Column:Category=Column
  2052. Column:Attrs:R=Type:"Type":"Length":1:ER
  2053. Column:EAttrs=Text,New,Delete,Modify,Rename
  2054. Column:Text:Get=`N ' ' EType EDefault``! ' ' =status`
  2055.  
  2056. Index:Category=Index
  2057. Index:Values=A.keycnt > 0
  2058. Index:Attrs:R=status::::+E
  2059. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  2060. Index:Text:Get1=CREATE `=status` INDEX `N`
  2061. Index:Text:Get2=ON `{<}N` (`{>IndexColumn}*`)
  2062. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  2063. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  2064. Index:Delete:Text=DROP INDEX `{<}O`.`O`
  2065.  
  2066. IndexColumn:Category=ColumnReference
  2067. IndexColumn:Name=Column
  2068. IndexColumn:Order=Id
  2069. IndexColumn:Definition1=Dataset=
  2070. IndexColumn:Definition2=select Id=c.colid, TabId=c.id, ColId=i.colid
  2071. IndexColumn:Definition3=from sysindexes x, syscolumns c, syscolumns i
  2072. IndexColumn:Definition4=where (x.id=`:id`) and (x.id=c.id) and (x.id=i.id) and
  2073. IndexColumn:Definition5=(x.name=`OQ`) and (c.colid<=keycnt) and
  2074. IndexColumn:Definition6=(i.name=INDEX_COL(`{<}OQ`,x.indid,c.colid))
  2075. IndexColumn:Dataset=Id=Word,TabId=Word,ColId=Word
  2076. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2077. IndexColumn:Attrs1=Id="Order":2:ER
  2078. IndexColumn:Attrs:R=Column:::2:ER
  2079. IndexColumn:Reference:"Column"=TabId,ColId
  2080. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  2081. IndexColumn:Text:Get=`N`
  2082.  
  2083. Parameter:Category=Column
  2084. Parameter:Attrs:R=Type:"Type":"Length":1
  2085. Parameter:EAttrs=
  2086.  
  2087. Type:Category=Type
  2088. Type:Attrs:T=dbo.sysusers.name=Owner:"Owner":Type:1
  2089. Type:AttrReference:Owner=uid=uid
  2090. Type:Warning=Loss
  2091. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  2092. Type:Text:Init=sp_addtype "`EDefaultName`", "varchar(255)", "null"
  2093. Type:Text:Get=sp_addtype "`N`", "`EType`"`! ', "' =Null '"'`
  2094. Type:Delete:Text=sp_droptype "`O`"
  2095.  
  2096. Login:Attrs:P=Password=String
  2097. Login:Attrs:R=Password:"Password":"Default Language":2
  2098. Login:EAttrs=Text
  2099. Login:Text:Get=sp_addlogin "`N`", "`=Password`", "`=dbname`", "`=language`"
  2100. Login:Delete:Text=sp_droplogin "`O`"
  2101.  
  2102. Group:Values=A.uid = A.gid
  2103. ; !!! Group:Objects=P:R:0M::"Users":User
  2104. Group:Reference:"Users"=uid=gid
  2105. Group:EAttrs=Text
  2106. Group:Text:Get=sp_addgroup "`N`"
  2107. Group:Delete:Text=sp_dropgroup "`O`"
  2108.  
  2109. User:Values=A.uid <> A.gid
  2110. User:Objects1=P:R:M1::"Login":Login
  2111. User:Objects2=P:R:M1::"Group":Group
  2112. User:Reference:"Login"=suid
  2113. User:Reference:"Group"=gid
  2114. User:EAttrs=Text
  2115. User:Text:Get=sp_adduser "`=Login`", "`N`", "`=Group`"
  2116. User:Delete:Text=sp_dropuser "`O`"
  2117.  
  2118. Segment:Objects=P:R:M0::"Device":Device
  2119. Segment:Attrs:P=DeviceName=String:::0
  2120. Segment:Reference:"Device"=DeviceName
  2121. Segment:EAttrs=Text
  2122. Segment:Text:Get=sp_addsegment "`N`","`=Device`"
  2123. Segment:Delete:Text=sp_dropsegment "`O`"
  2124.  
  2125. Device:EAttrs=Text
  2126. Device:Text:Get1=DISK INIT NAME="`N`",`\N'  '`PHYSNAME="`=phyname`",
  2127. Device:Text:Get2=`\N'  '`VDEVNO=?,`\N'  '`SIZE=?,
  2128. Device:Text:Get3=`\N'  '`CNTRLTYPE=`=cntrltype`
  2129. Device:Delete:Text=sp_dropdevice "`O`"
  2130.  
  2131. [SYBASE 10 Properties]
  2132. dbo.systypes:Attrs1=type=Type="Physical Type"::ER:::VM=TPhysicalType
  2133. dbo.systypes:Attrs2=length=Length="Length"::E
  2134. dbo.systypes:Attrs3=prec=Precision="Precision":2:E
  2135. dbo.systypes:Attrs4=scale=Scale="Scale":2:E
  2136. dbo.systypes:Attrs5=allownulls=Null="Nulls"::E:::VM=TNull01
  2137. dbo.systypes:Attrs6=variable="Variable Length":::::VM=TBooleanYN
  2138.  
  2139. dbo.syscolumns:Attrs1=colid="Order":2:ER
  2140. dbo.syscolumns:Attrs2=length=Length="Length"::E
  2141. dbo.syscolumns:Attrs3=prec=Precision="Precision":2:E
  2142. dbo.syscolumns:Attrs4=scale=Scale="Scale":2:E
  2143. dbo.syscolumns:Attrs5=status="Status"::E:::VS=TColumnStatus:$8
  2144.  
  2145. dbo.sysconstraints:Key=tableid,constrid
  2146. dbo.sysconstraints:Name=name
  2147.  
  2148. dbo.sysreferences:Key=tableid,constrid
  2149. dbo.sysreferences:Name=name
  2150.  
  2151. Table:Objects1=T:P:1M::"Columns":Column
  2152. Table:Objects2=T:O:0M::"Indices":Index
  2153. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  2154. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  2155. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  2156. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  2157. Table:Objects7=T:O:0M::"Triggers":Trigger
  2158.  
  2159. KeyColumn:Category=ColumnReference
  2160. KeyColumn:Definition=Dataset
  2161. KeyColumn:Dataset=ItemNo=Integer,ColNo=Integer
  2162. KeyColumn:Name=Column
  2163. KeyColumn:Order=ItemNo
  2164. KeyColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2165. KeyColumn:Attrs1=ItemNo="Order":2:ER
  2166. KeyColumn:Attrs:R=Column:::2:ER
  2167. KeyColumn:Reference:"Column"=,ColNo
  2168. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  2169. KeyColumn:Text:Get=`N`
  2170.  
  2171. PrimaryKey:Definition=Root=dbo.sysindexes
  2172. PrimaryKey:Category=PrimaryKey
  2173. PrimaryKey:Values=(A.status2 & 2 <> 0) and (A.status & 2048 <> 0)
  2174. PrimaryKey:Objects1=P:R:M1::"Index":Index:<>Index
  2175. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2176. PrimaryKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  2177. PrimaryKey:Text:Init2= PRIMARY KEY (`{>IndexColumn}*`)
  2178. PrimaryKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  2179. PrimaryKey:Text:Get2= PRIMARY KEY (`{>IndexColumn}*`)
  2180. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2181.  
  2182. ForeignKey:Definition=Root=dbo.sysreferences
  2183. ForeignKey:Category=ForeignKey
  2184. ; ForeignKey:Values=C.type = 'RI'
  2185. ForeignKey:Objects1=M:P:1M::"Columns":KeyColumn:GetKeyColumns
  2186. ForeignKey:Objects2=P:R:M1::"Reference Table":Table
  2187. ForeignKey:Attrs:T1=dbo.sysobjects.name=name:::0
  2188. ForeignKey:Attrs:T2=dbo.sysobjects.crdate=crdate
  2189. ForeignKey:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  2190. ForeignKey:Attrs:R=Table::::ER
  2191. ForeignKey:Reference:"Columns":Text=`[KeyColumn:%s,%s:*]`
  2192. ForeignKey:Reference:"Reference Table"=reftabid
  2193. ForeignKey:AttrReference:name=constrid=id
  2194. ForeignKey:AttrReference:crdate=constrid=id
  2195. ForeignKey:AttrReference:sysstat=constrid=id
  2196. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2197. ForeignKey:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  2198. ForeignKey:Text:Init2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  2199. ForeignKey:Text:Init3= REFERENCES `=Table`
  2200. ForeignKey:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  2201. ForeignKey:Text:Get2= FOREIGN KEY (`{>KeyColumn}*`) `\N`
  2202. ForeignKey:Text:Get3= REFERENCES `=Table`
  2203. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2204.  
  2205. UniqueConstraint:Definition=Root=dbo.sysindexes
  2206. UniqueConstraint:Category=UniqueConstraint
  2207. UniqueConstraint:Values=(A.status2 & 2 <> 0) and (A.status & 2048 = 0)
  2208. UniqueConstraint:Objects1=P:R:M1::"Index":Index:<>Index
  2209. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2210. UniqueConstraint:Text:Init1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`
  2211. UniqueConstraint:Text:Init2= UNIQUE (`{>IndexColumn}*`)
  2212. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`
  2213. UniqueConstraint:Text:Get2= UNIQUE (`{>IndexColumn}*`)
  2214. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2215.  
  2216. CheckConstraint:Definition=Root=dbo.sysconstraints
  2217. CheckConstraint:Values=B.sysstat & 15 = 7
  2218. ; B.type = 'R'
  2219. CheckConstraint:Category=Expression
  2220. CheckConstraint:Attrs:T1=dbo.sysobjects.name=name:::0
  2221. CheckConstraint:Attrs:T2=dbo.sysobjects.crdate=crdate
  2222. CheckConstraint:Attrs:T3=dbo.sysobjects.sysstat=sysstat
  2223. CheckConstraint:Attrs:Q=Text=String:255:"Constraint Text":2:ER:PStripCheck
  2224. CheckConstraint:AttrReference:name=constrid=id
  2225. CheckConstraint:AttrReference:crdate=constrid=id
  2226. CheckConstraint:AttrReference:sysstat=constrid=id
  2227. CheckConstraint:AttrReference:Text1=select text from dbo.syscomments
  2228. CheckConstraint:AttrReference:Text2=where id=`:constrid` order by colid
  2229. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2230. CheckConstraint:Text:Init=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  2231. CheckConstraint:Text:Get=ALTER TABLE `{<}N \N`  ADD CONSTRAINT `N \N`  CHECK (`=Text`)
  2232. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  2233. CheckConstraint:Text:Set=1=`{<}N`,*N=2,Text=3
  2234. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2235.  
  2236.  
  2237.  
  2238. [INTRBASE Properties]
  2239. TFieldType:Values1=Closed,7=SMALLINT,8=INTEGER,9=QUAD,10=FLOAT
  2240. TFieldType:Values2=11=DOUBLE PRECISION,14=`'CHAR('=Length')'`:CHAR,27=NUMERIC
  2241. TFieldType:Values3=35=DATE,37=`'VARCHAR('=Length')'`:VARCHAR
  2242. TFieldType:Values4=40=`'CSTRING('=Length')'`:CSTRING
  2243. TFieldType:Values5=261=`'BLOB'``!' SUB_TYPE ' =SubType`:BLOB
  2244. TFieldSubType:Values1=Closed,0=0:,1=1:"Text",2=2:"BLR",3=3:"ACL",4=4:"Ranges",5=5:"Summary"
  2245. TFieldSubType:Values2=6=6:"Format",7=7:"Transaction Desc",8=8:"Ext File Desc"
  2246. TNulls:Values=Closed,=:"Yes",1=NOT NULL:"No"
  2247. TUniqueIndex:Values=Closed,=:"No",0=:"No",1=UNIQUE:"Yes"
  2248. TDescendingIndex:Values=Closed,=ASCENDING:"No",1=DESCENDING:"Yes"
  2249. TTriggerType:Values1=Closed,1=BEFORE INSERT,2=AFTER INSERT,3=BEFORE UPDATE
  2250. TTriggerType:Values2=4=AFTER UPDATE,5=BEFORE DELETE,6=AFTER DELETE
  2251. TParamKind:Values=Closed,0=:"Input",1=:"Output"
  2252. TFnParamKind:Values=Closed,0=BY VALUE:"Value",1=:"Reference",3=:"Handle"
  2253.  
  2254. INTRBASE:Comments=/*,*/
  2255.  
  2256. INTRBASE:Objects1=O:C:0M::"Domains":Type
  2257. INTRBASE:Objects2=O:C:0M::"Tables":Table
  2258. INTRBASE:Objects3=O:C:0M::"Views":View
  2259. INTRBASE:Objects4=O:C:0M::"Procedures":Procedure
  2260. INTRBASE:Objects5=O:C:0M::"Functions":Function
  2261. INTRBASE:Objects6=O:C:0M::"Generators":Generator
  2262. INTRBASE:Objects7=O:C:0M::"Exceptions":Exception
  2263. INTRBASE:Objects8=O:C:0M::"Blob Filters":BlobFilter
  2264.  
  2265. RDB$RELATIONS:Name=RDB$RELATION_NAME
  2266. RDB$RELATIONS:Attrs1=RDB$OWNER_NAME="Owner"
  2267. RDB$RELATIONS:Attrs2=RDB$DESCRIPTION="Description"
  2268. RDB$RELATIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2269.  
  2270. RDB$RELATION_FIELDS:Key=RDB$RELATION_NAME,RDB$FIELD_NAME
  2271. RDB$RELATION_FIELDS:Name=RDB$FIELD_NAME
  2272. RDB$RELATION_FIELDS:Order=RDB$FIELD_POSITION
  2273. RDB$RELATION_FIELDS:Objects=P:R:M1::"Domain":Type
  2274. RDB$RELATION_FIELDS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  2275. RDB$RELATION_FIELDS:Attrs2=RDB$DEFAULT_SOURCE=Default="Default"::E
  2276. RDB$RELATION_FIELDS:Attrs3=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  2277. RDB$RELATION_FIELDS:Reference:"Domain"=RDB$FIELD_SOURCE
  2278.  
  2279. RDB$FIELDS:Name=RDB$FIELD_NAME
  2280. RDB$FIELDS:Attrs1=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  2281. RDB$FIELDS:Attrs2=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  2282. RDB$FIELDS:Attrs3=RDB$FIELD_LENGTH=Length="Length"::E
  2283. RDB$FIELDS:Attrs4=RDB$FIELD_SCALE=Scale="Scale"::E
  2284. RDB$FIELDS:Attrs5=RDB$NULL_FLAG=Null="Nulls"::E:::VM=TNulls
  2285. RDB$FIELDS:Attrs6=RDB$SEGMENT_LENGTH=SegmentSize="Segment Size":2:E
  2286. RDB$FIELDS:Attrs7=RDB$DEFAULT_SOURCE=Default="Default":2:E
  2287. RDB$FIELDS:Attrs8=RDB$VALIDATION_SOURCE=Rule="Constraint":2:E
  2288. RDB$FIELDS:Attrs9=RDB$DESCRIPTION=Description="Description"
  2289.  
  2290. RDB$FIELD_DIMENSIONS:Key=RDB$FIELD_NAME,RDB$DIMENSION
  2291. RDB$FIELD_DIMENSIONS:Name=RDB$DIMENSION
  2292. RDB$FIELD_DIMENSIONS:Order=RDB$DIMENSION
  2293. RDB$FIELD_DIMENSIONS:Attrs1=RDB$DIMENSION="Order":2:ER
  2294. RDB$FIELD_DIMENSIONS:Attrs2=RDB$LOWER_BOUND=LowerBound="Lower Bound"::ER
  2295. RDB$FIELD_DIMENSIONS:Attrs3=RDB$UPPER_BOUND=UpperBound="Upper Bound"::ER
  2296.  
  2297. RDB$FUNCTIONS:Name=RDB$FUNCTION_NAME
  2298. RDB$FUNCTIONS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  2299. RDB$FUNCTIONS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  2300. RDB$FUNCTIONS:Attrs3=RDB$QUERY_NAME=AlternateName="Alternate Name"
  2301. RDB$FUNCTIONS:Attrs4=RDB$DESCRIPTION=Description="Description":2
  2302. RDB$FUNCTIONS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2303.  
  2304. RDB$FUNCTION_ARGUMENTS:Key=RDB$FUNCTION_NAME,RDB$ARGUMENT_POSITION
  2305. RDB$FUNCTION_ARGUMENTS:Name=RDB$ARGUMENT_POSITION
  2306. RDB$FUNCTION_ARGUMENTS:Order=RDB$ARGUMENT_POSITION
  2307. RDB$FUNCTION_ARGUMENTS:Attrs1=RDB$ARGUMENT_POSITION="Order":2:ER
  2308. RDB$FUNCTION_ARGUMENTS:Attrs2=RDB$FIELD_TYPE=FieldType="Type"::ER:::VM=TFieldType
  2309. RDB$FUNCTION_ARGUMENTS:Attrs3=RDB$FIELD_SUB_TYPE=SubType="Subtype"::E:::VM=TFieldSubType
  2310. RDB$FUNCTION_ARGUMENTS:Attrs4=RDB$FIELD_LENGTH=Length="Length"::E
  2311. RDB$FUNCTION_ARGUMENTS:Attrs5=RDB$FIELD_SCALE=Scale="Scale"::E
  2312.  
  2313. RDB$FILTERS:Name=RDB$FUNCTION_NAME
  2314. RDB$FILTERS:Attrs1=RDB$MODULE_NAME=Module="Module"::ER
  2315. RDB$FILTERS:Attrs2=RDB$ENTRYPOINT=Entry="Entry"::ER
  2316. RDB$FILTERS:Attrs3=RDB$INPUT_SUB_TYPE=InputType="Input"::ER:::VM=TFieldSubType
  2317. RDB$FILTERS:Attrs4=RDB$OUTPUT_SUB_TYPE=OutputType="Output"::ER:::VM=TFieldSubType
  2318. RDB$FILTERS:Attrs5=RDB$DESCRIPTION=Description="Description":2
  2319. RDB$FILTERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2320.  
  2321. RDB$INDICES:Name=RDB$INDEX_NAME
  2322. RDB$INDICES:Objects=T:P:1M::"Columns":IndexColumn
  2323. RDB$INDICES:Attrs1=RDB$UNIQUE_FLAG=Unique="Unique"::E:::VM=TUniqueIndex
  2324. RDB$INDICES:Attrs2=RDB$INDEX_TYPE=Descending="Descending"::E:::VM=TDescendingIndex
  2325. RDB$INDICES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2326.  
  2327. RDB$INDEX_SEGMENTS:Key=RDB$INDEX_NAME,RDB$FIELD_NAME
  2328. RDB$INDEX_SEGMENTS:Name=Column
  2329. RDB$INDEX_SEGMENTS:Order=RDB$FIELD_POSITION
  2330. RDB$INDEX_SEGMENTS:Objects1=P:R:M1::"Column":Column:<<>Column
  2331. RDB$INDEX_SEGMENTS:Attrs1=RDB$FIELD_POSITION="Order":2:ER
  2332. RDB$INDEX_SEGMENTS:Reference:"Column"=,RDB$FIELD_NAME
  2333.  
  2334. RDB$PROCEDURES:Name=RDB$PROCEDURE_NAME
  2335. RDB$PROCEDURES:Attrs1=RDB$OWNER_NAME="Owner"
  2336. RDB$PROCEDURES:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2337.  
  2338. RDB$PROCEDURE_PARAMETERS:Key=RDB$PROCEDURE_NAME,RDB$PARAMETER_NAME
  2339. RDB$PROCEDURE_PARAMETERS:Name=RDB$PARAMETER_NAME
  2340. RDB$PROCEDURE_PARAMETERS:Order=RDB$PARAMETER_NUMBER
  2341. RDB$PROCEDURE_PARAMETERS:Objects=P:R:M1::"Domain":Type
  2342. RDB$PROCEDURE_PARAMETERS:Attrs1=RDB$PARAMETER_NUMBER="Order":2
  2343. RDB$PROCEDURE_PARAMETERS:Attrs2=RDB$PARAMETER_TYPE=Kind="Kind":1:ER:::VM=TParamKind
  2344. RDB$PROCEDURE_PARAMETERS:Reference:"Domain"=RDB$FIELD_SOURCE
  2345.  
  2346. RDB$TYPES:Key=RDB$FIELD_NAME,RDB$TYPE
  2347. RDB$TYPES:Name=RDB$TYPE_NAME
  2348. RDB$TYPES:Order=RDB$TYPE
  2349. RDB$TYPES:Attrs=RDB$TYPE="Value"
  2350.  
  2351. RDB$GENERATORS:Name=RDB$GENERATOR_NAME
  2352. RDB$GENERATORS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2353.  
  2354. RDB$EXCEPTIONS:Name=RDB$EXCEPTION_NAME
  2355. RDB$EXCEPTIONS:Attrs1=RDB$MESSAGE=Message="Message"::E
  2356.  
  2357. RDB$TRIGGERS:Key=RDB$RELATION_NAME,RDB$TRIGGER_NAME
  2358. RDB$TRIGGERS:Name=RDB$TRIGGER_NAME
  2359. RDB$TRIGGERS:Attrs1=RDB$TRIGGER_TYPE=Type="Type"::ER:::VM=TTriggerType
  2360. RDB$TRIGGERS:Attrs2=RDB$TRIGGER_SEQUENCE=Position="Position"::ER
  2361. RDB$TRIGGERS:FilterSystemObjects=A.RDB$SYSTEM_FLAG <> 1 or A.RDB$SYSTEM_FLAG IS NULL
  2362.  
  2363. RDB$RELATION_CONSTRAINTS:Key=RDB$RELATION_NAME,RDB$CONSTRAINT_NAME
  2364. RDB$RELATION_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  2365. RDB$RELATION_CONSTRAINTS:Attrs1=RDB$DEFERRABLE="Can Defer"
  2366. RDB$RELATION_CONSTRAINTS:Attrs2=RDB$INITIALLY_DEFERRED="Initially Deferred"
  2367. RDB$RELATION_CONSTRAINTS:Reference:"Columns"=RDB$INDEX_NAME
  2368.  
  2369. RDB$REF_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  2370. RDB$REF_CONSTRAINTS:Objects1=P:R:01::"Primary Key":PrimaryKey
  2371. RDB$REF_CONSTRAINTS:Objects2=P:R:11::"Foreign Key":ForeignKey
  2372. RDB$REF_CONSTRAINTS:Attrs1=RDB$CONSTRAINT_NAME="Foreign Key"
  2373. RDB$REF_CONSTRAINTS:Attrs2=RDB$CONST_NAME_UQ="Primary Key"
  2374. RDB$REF_CONSTRAINTS:Attrs3=RDB$MATCH_OPTION="Match Option"
  2375. RDB$REF_CONSTRAINTS:Attrs4=RDB$UPDATE_RULE="Update Rule"
  2376. RDB$REF_CONSTRAINTS:Attrs5=RDB$DELETE_RULE="Delete Rule"
  2377. RDB$REF_CONSTRAINTS:Reference:"PrimaryKey"=RDB$CONST_NAME_UQ=RDB$CONSTRAINT_NAME
  2378. RDB$REF_CONSTRAINTS:Reference:"ForeignKey"=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  2379.  
  2380. RDB$CHECK_CONSTRAINTS:Name=RDB$CONSTRAINT_NAME
  2381. RDB$CHECK_CONSTRAINTS:Attrs=RDB$TRIGGER_NAME="Trigger"
  2382.  
  2383. Table:Definition=Root=RDB$RELATIONS
  2384. View:Definition=Root=RDB$RELATIONS
  2385. Procedure:Definition=Root=RDB$PROCEDURES
  2386. Function:Definition=Root=RDB$FUNCTIONS
  2387. Trigger:Definition=Root=RDB$TRIGGERS
  2388. PrimaryKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  2389. ForeignKey:Definition=Root=RDB$RELATION_CONSTRAINTS
  2390. UniqueConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  2391. CheckConstraint:Definition=Root=RDB$RELATION_CONSTRAINTS
  2392. Exception:Definition=Root=RDB$EXCEPTIONS
  2393. Generator:Definition=Root=RDB$GENERATORS
  2394. Index:Definition=Root=RDB$INDICES
  2395. IndexColumn:Definition=Root=RDB$INDEX_SEGMENTS
  2396. Column:Definition=Root=RDB$RELATION_FIELDS
  2397. Type:Definition=Root=RDB$FIELDS
  2398. Enumeration:Definition=Root=RDB$TYPES
  2399. Parameter:Definition=Root=RDB$PROCEDURE_PARAMETERS
  2400. FunctionParameter:Definition=Root=RDB$FUNCTION_ARGUMENTS
  2401. FunctionResult:Definition=Root=RDB$FUNCTION_ARGUMENTS
  2402. BlobFilter:Definition=Root=RDB$FILTERS
  2403. Dimension:Definition=Root=RDB$FIELD_DIMENSIONS
  2404.  
  2405. Exception:Warning=Loss
  2406. Exception:EAttrs=Text,New,Delete,Modify,Rename,Save
  2407. Exception:Text:Get=CREATE EXCEPTION `\N '  ' N \N`  "`=Message`"
  2408. Exception:Text:RE=CREATE EXCEPTION\_+(\w+)\_+"(.*)"
  2409. Exception:Text:Set=*N=1,Message=2
  2410. Exception:Delete:Text=DROP EXCEPTION `O`
  2411.  
  2412. Generator:Attrs:Q=gen_id=Integer::"Current Value":2:ER
  2413. Generator:AttrReference:gen_id=select distinct gen_id(`O`, 0) from RDB$GENERATORS
  2414. Generator:Warning=Loss
  2415. Generator:EAttrs=Text,New:';',Delete,Modify,Rename,Save
  2416. Generator:Text:Init1=CREATE GENERATOR `EDefaultName ';' \N`
  2417. Generator:Text:Init2=SET GENERATOR `EDefaultName` TO 0
  2418. Generator:Text:Get=CREATE GENERATOR `N`;`\N 'SET GENERATOR ' N ' TO ' =gen_id`
  2419. Generator:Text:RE=CREATE GENERATOR\_+(\w+);(\_*SET GENERATOR \w+ TO (\w*))?\_*$
  2420. Generator:Text:Set=*N=1,gen_id=3
  2421. Generator:Delete:Text1=DELETE FROM RDB$GENERATORS
  2422. Generator:Delete:Text2=WHERE RDB$GENERATOR_NAME=`OQ`
  2423.  
  2424. Table:Category=Dataset
  2425. Table:Values=A.RDB$VIEW_SOURCE IS NULL
  2426. Table:Objects1=T:P:1M::"Columns":Column
  2427. Table:Objects2=T:O:0M::"Indices":Index
  2428. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  2429. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  2430. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  2431. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  2432. Table:Objects7=T:O:0M::"Triggers":Trigger
  2433. Table:Reference:"Indices"=RDB$RELATION_NAME=RDB$RELATION_NAME
  2434. Table:Warning=DataLoss
  2435. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2436. Table:Text:Get=CREATE TABLE `N` (`[Column:%s,%s:\N '  ' *] \N`)
  2437. Table:Text:RE=CREATE TABLE\_+(\w+)\_*(\(.*\))
  2438. Table:Text:Set=*N=1
  2439. Table:Delete:Text=DROP TABLE `O`
  2440.  
  2441. View:Category=Dataset
  2442. View:Values=A.RDB$VIEW_SOURCE IS NOT NULL
  2443. View:Objects=T:P:0M:NMDR:"Columns":Column
  2444. View:Attrs:Q=Text=Memo::"Text"::ER
  2445. View:AttrReference:Text1=select RDB$VIEW_SOURCE from RDB$RELATIONS
  2446. View:AttrReference:Text2=where RDB$RELATION_ID=`:RDB$RELATION_ID`
  2447. View:Warning=Loss
  2448. View:EAttrs=Data,Text,New,Modify,Rename,Delete,Save
  2449. View:Text:Init=CREATE VIEW `EDefaultName` AS SELECT
  2450. View:Text:Get=CREATE VIEW `N` `'('[Column:%s,%s:\N '  ' N] \N ') '`AS`=Text`
  2451. View:Text:RE=CREATE VIEW\_+(\w+)\_*(\(.*\))?\_+AS(.*)
  2452. View:Text:Set=Text=3,*N=1
  2453. View:Delete:Text=DROP VIEW `O`
  2454.  
  2455. Index:Category=Index
  2456. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  2457. Index:Text:Get1=CREATE `!=Unique ' ' ``!=Descending ' ' `INDEX `N`
  2458. Index:Text:Get2=ON `{<}N` (`[IndexColumn:%s, %s:*]`)
  2459. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  2460. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  2461. Index:Delete:Text=DROP INDEX `O`
  2462.  
  2463. Column:Category=Column
  2464. Column:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:E::PResetType
  2465. Column:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:E::PResetType
  2466. Column:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:E::PResetType
  2467. Column:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:E::PResetType
  2468. Column:Attrs:R=Type:"Domain":"Type":1:E::PSetType
  2469. Column:OnAfterLoad=ColumnLoaded
  2470. Column:OnCopyFrom=CopyWithDomain
  2471. Column:AttrReference:FieldType=RDB$FIELD_SOURCE
  2472. Column:AttrReference:SubType=RDB$FIELD_SOURCE
  2473. Column:AttrReference:Length=RDB$FIELD_SOURCE
  2474. Column:AttrReference:Scale=RDB$FIELD_SOURCE
  2475. Column:EAttrs=Text,New,Delete,Modify,Rename
  2476. Column:Text:Get=`N ' ' EType``! ' DEFAULT ' =Default``! ' ' =Null`
  2477.  
  2478. IndexColumn:Category=ColumnReference
  2479. IndexColumn:Attrs:R=Column:::2:ER
  2480. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  2481. IndexColumn:Text:Get=`N`
  2482.  
  2483. Type:Category=Type
  2484. Type:Objects1=T:P:0M::"Dimensions":Dimension
  2485. Type:Objects2=T:C:0M::"Values":Enumeration
  2486. ; Convert DEFAULT (.*) in Default and CHECK \((.*)\) in Rule
  2487. Type:OnAfterLoad=TypeLoaded
  2488. Type:Reference:"Dimensions":Text=`' [' [Dimension:%s, %s:*] ']'`
  2489. Type:Warning=Loss
  2490. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  2491. Type:Text:Get1=CREATE DOMAIN `N` AS` \N '  ' EPhysicalType`
  2492. Type:Text:Get2=`!\N '  DEFAULT '=Default`
  2493. Type:Text:Get3=`!\N '  ' =Null`
  2494. Type:Text:Get4=`!\N '  CHECK (' =Rule ')'`
  2495. Type:Delete:Text=DROP DOMAIN `O`
  2496.  
  2497. Dimension:EAttrs=Text,New,Delete,Modify,Rename
  2498. Dimension:Text:Get=`=LowerBound ':' =UpperBound`
  2499.  
  2500. Procedure:Category=Executable
  2501. Procedure:Objects=T:P:0M::"Parameters":Parameter
  2502. Procedure:Reference:"Parameters":Text1=`!'(' \N {>Parameter} EParametersIn \N')'`
  2503. Procedure:Reference:"Parameters":Text2=`!'RETURNS (' \N {>Parameter} EParametersOut \N ')'`
  2504. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  2505. Procedure:AttrReference:Text1=select RDB$PROCEDURE_SOURCE from RDB$PROCEDURES
  2506. Procedure:AttrReference:Text2=where RDB$PROCEDURE_NAME=`OQ`
  2507. Procedure:Warning=Loss
  2508. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2509. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName` AS`\N`BEGIN`\N`END
  2510. Procedure:Text:Get1=CREATE PROCEDURE `N`
  2511. Procedure:Text:Get2=`{>Parameter} *`
  2512. Procedure:Text:Get3=AS `=Text`
  2513. Procedure:Text:RE=CREATE PROCEDURE\_+(\w+)\_*(.*)\_AS\_(.*)
  2514. Procedure:Text:Set=Text=3,*>Parameter=2,*N=1
  2515. Procedure:Modify:RE=(CREATE)\_+PROCEDURE
  2516. Procedure:Modify:Set=1=`'ALTER'`
  2517. Procedure:Delete:Text=DROP PROCEDURE `O`
  2518.  
  2519. Parameter:Category=Column
  2520. Parameter:Attrs:T1=RDB$FIELDS.RDB$FIELD_TYPE=FieldType:"Type":"Default":1:-E::PResetType
  2521. Parameter:Attrs:T2=RDB$FIELDS.RDB$FIELD_SUB_TYPE=SubType:"Subtype":"Default":1:-E::PResetType
  2522. Parameter:Attrs:T3=RDB$FIELDS.RDB$FIELD_LENGTH=Length:"Length":"Default":1:-E::PResetType
  2523. Parameter:Attrs:T4=RDB$FIELDS.RDB$FIELD_SCALE=Scale:"Scale":"Default":1:-E::PResetType
  2524. Parameter:Attrs:R=Type:"Domain":"Type":1:::PSetType
  2525. Parameter:AttrReference:FieldType=RDB$FIELD_SOURCE
  2526. Parameter:AttrReference:SubType=RDB$FIELD_SOURCE
  2527. Parameter:AttrReference:Length=RDB$FIELD_SOURCE
  2528. Parameter:AttrReference:Scale=RDB$FIELD_SOURCE
  2529. Parameter:EAttrs=Text
  2530. Parameter:Text:Get=`N ' ' EType`
  2531. Parameter:OnAfterLoad=AdjustTypeInfo
  2532. Parameter:OnCopyFrom=CopyWithDomain
  2533.  
  2534. Function:Category=Executable
  2535. Function:Objects1=T:P:0M::"Parameters":FunctionParameter
  2536. Function:Objects2=T:P:11::"Result":FunctionResult
  2537. Function:Reference:"Parameters":Text=`[FunctionParameter:%s, %s:*]`
  2538. Function:Reference:"Result":Text=`[FunctionResult::*]`
  2539. Function:Warning=Loss
  2540. Function:EAttrs=Text,New,Delete,Modify,Rename,Save
  2541. Function:Text:Get1=DECLARE EXTERNAL FUNCTION `N \N`
  2542. Function:Text:Get2=`!'  ' {>FunctionParameter} * \N`
  2543. Function:Text:Get3=`'  RETURNS ' {>FunctionResult} * \N`
  2544. Function:Text:Get4= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  2545. Function:Delete:Text=DROP EXTERNAL FUNCTION `O`
  2546.  
  2547. FunctionParameter:Category=Column
  2548. FunctionParameter:Values=A.RDB$ARGUMENT_POSITION <> `:RDB$RETURN_ARGUMENT`
  2549. FunctionParameter:EAttrs=Text,New,Delete,Modify,Rename
  2550. FunctionParameter:Text:Get=`EPhysicalType`
  2551.  
  2552. FunctionResult:Category=Column
  2553. FunctionResult:Values=A.RDB$ARGUMENT_POSITION = `:RDB$RETURN_ARGUMENT`
  2554. FunctionResult:Attrs=RDB$MECHANISM=Kind="Kind"::E:::VM=TFnParamKind
  2555. FunctionResult:EAttrs=Text,New,Delete,Modify,Rename
  2556. FunctionResult:Text:Get=`EPhysicalType``! ' ' =Kind`
  2557.  
  2558. BlobFilter:Category=Executable
  2559. BlobFilter:Warning=Loss
  2560. BlobFilter:EAttrs=Text,New,Delete,Modify,Rename,Save
  2561. BlobFilter:Text:Get1=DECLARE FILTER `N \N`
  2562. BlobFilter:Text:Get2= INPUT_TYPE `=InputType`  OUTPUT_TYPE `=OutputType``\N`
  2563. BlobFilter:Text:Get3= ENTRY_POINT "`=Entry`"  MODULE_NAME "`=Module`"
  2564. BlobFilter:Delete:Text=DROP FILTER `O`
  2565.  
  2566. CheckConstraint:Category=Expression
  2567. CheckConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'CHECK'
  2568. CheckConstraint:Attrs:Q=Text=Memo::"Constraint Text":2:ER:PStripCheck
  2569. CheckConstraint:AttrReference:Text1=select t.RDB$TRIGGER_SOURCE
  2570. CheckConstraint:AttrReference:Text2=from RDB$TRIGGERS t, RDB$CHECK_CONSTRAINTS c
  2571. CheckConstraint:AttrReference:Text3=where t.RDB$TRIGGER_NAME=c.RDB$TRIGGER_NAME and
  2572. CheckConstraint:AttrReference:Text4=t.RDB$TRIGGER_TYPE=1 and
  2573. CheckConstraint:AttrReference:Text5=c.RDB$CONSTRAINT_NAME=`OQ`
  2574. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2575. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `EDefaultName \N`  CHECK ()
  2576. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  2577. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  2578. CheckConstraint:Text:Set=1=`{<}N`,Text=3,*N=2
  2579. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2580.  
  2581. UniqueConstraint:Category=UniqueConstraint
  2582. UniqueConstraint:Values=A.RDB$CONSTRAINT_TYPE = 'UNIQUE'
  2583. UniqueConstraint:Objects1=T:P:1M::"Columns":IndexColumn
  2584. UniqueConstraint:Objects2=P:R:M1::"Index":Index:<>Index
  2585. UniqueConstraint:Reference:"Columns"=RDB$INDEX_NAME
  2586. UniqueConstraint:Reference:"Index"=RDB$INDEX_NAME
  2587. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2588. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  2589. UniqueConstraint:Text:Get2=`\N`  UNIQUE `'(' [IndexColumn:%s, %s:N] ')'`
  2590. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2591.  
  2592. PrimaryKey:Category=PrimaryKey
  2593. PrimaryKey:Values=A.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
  2594. PrimaryKey:Objects1=T:P:1M::"Columns":IndexColumn
  2595. PrimaryKey:Objects2=P:R:M1::"Index":Index:<>Index
  2596. PrimaryKey:Reference:"Columns"=RDB$INDEX_NAME
  2597. PrimaryKey:Reference:"Index"=RDB$INDEX_NAME
  2598. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2599. PrimaryKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  2600. PrimaryKey:Text:Get2=`\N`  PRIMARY KEY `'(' [IndexColumn:%s, %s:N] ')'`
  2601. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2602.  
  2603. ForeignKey:Category=ForeignKey
  2604. ForeignKey:Values=A.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
  2605. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  2606. ForeignKey:Objects2=T:P:1M::"Columns":IndexColumn
  2607. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  2608. ForeignKey:Reference:"Index"=RDB$INDEX_NAME
  2609. ForeignKey:Reference:"Columns"=RDB$INDEX_NAME
  2610. ForeignKey:Reference:"Reference Table"=ReferenceTable
  2611. ForeignKey:Attrs:T1=RDB$REF_CONSTRAINTS.RDB$MATCH_OPTION=MatchOption
  2612. ForeignKey:Attrs:T2=RDB$REF_CONSTRAINTS.RDB$UPDATE_RULE=UpdateRule
  2613. ForeignKey:Attrs:T3=RDB$REF_CONSTRAINTS.RDB$DELETE_RULE=DeleteRule
  2614. ForeignKey:Attrs:Q=ReferenceTable=String:::0
  2615. ForeignKey:Attrs:R=Table::::ER
  2616. ForeignKey:AttrReference:ReferenceTable1=select RDB$RELATION_NAME
  2617. ForeignKey:AttrReference:ReferenceTable2=from RDB$REF_CONSTRAINTS A, RDB$RELATION_CONSTRAINTS B
  2618. ForeignKey:AttrReference:ReferenceTable3=where A.RDB$CONST_NAME_UQ = B.RDB$CONSTRAINT_NAME
  2619. ForeignKey:AttrReference:ReferenceTable4=and A.RDB$CONSTRAINT_NAME = `:RDB$CONSTRAINT_NAME`
  2620. ForeignKey:AttrReference:MatchOption=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  2621. ForeignKey:AttrReference:UpdateRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  2622. ForeignKey:AttrReference:DeleteRule=RDB$CONSTRAINT_NAME=RDB$CONSTRAINT_NAME
  2623. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2624. ForeignKey:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N`
  2625. ForeignKey:Text:Get2=`\N`  FOREIGN KEY `'(' [IndexColumn:%s, %s:N] ')'`
  2626. ForeignKey:Text:Get3=`\N`  REFERENCES `=Table`
  2627. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2628.  
  2629. Trigger:Category=Executable
  2630. Trigger:Attrs:Q=Text=Memo::"Text"::ER:PROOName
  2631. Trigger:AttrReference:Text1=select RDB$TRIGGER_SOURCE from RDB$TRIGGERS
  2632. Trigger:AttrReference:Text2=where RDB$TRIGGER_NAME=`OQ`
  2633. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  2634. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName` FOR `{<}N`
  2635. Trigger:Text:Init2=AFTER UPDATE POSITION 0 AS`\N`BEGIN`\N`END
  2636. Trigger:Text:Get1=CREATE TRIGGER `N` FOR `{<}N`
  2637. Trigger:Text:Get2=`=Type` POSITION `=Position` `=Text`
  2638. Trigger:Text:RE=CREATE\_+TRIGGER\_+(\w+)\_+FOR\_+(\w+)\_+(\w+\_\w+)\_+POSITION\_+(\w+)\_+(.*)
  2639. Trigger:Text:Set=*N=1,2=`{<}N`,Type=3,Position=4,Text=5
  2640. Trigger:Delete:Text=DROP TRIGGER `O`
  2641.  
  2642.  
  2643.  
  2644. [INFORMIX Properties]
  2645. TLockMode:Values=Closed,B=PAGE:"Page",P=PAGE:"Page",R=ROW:"Row"
  2646. TUnique:Values=Closed,-=:"No",U=UNIQUE:"Yes",D=:"No"
  2647. TClustered:Values=Closed,=:"No",-=:"No",C=CLUSTER:"Yes"
  2648. TDescending:Values=Closed,1=ASC:"No",-1=DESC:"Yes"
  2649. TMode:Values=Closed,P=DBA,O=Owner
  2650. TRule:Values=Closed,R=RESTRICT:"Restrict"
  2651. TDataType:Values1=Closed,0=`'CHAR(' =Length ')'`:CHAR,1=SMALLINT,2=INTEGER,3=FLOAT
  2652. TDataType:Values2=4=SMALLFLOAT,5=DECIMAL,6=SERIAL(1):SERIAL,7=DATE
  2653. TDataType:Values3=8=MONEY,10=DATETIME,11=BYTE,12=TEXT,13=VARCHAR,14=INTERVAL
  2654. TNull01:Values=Closed,0=:"Yes",1=NOT NULL:"No"
  2655.  
  2656. INFORMIX:UserName=select user from informix.systables where tabid=99
  2657. INFORMIX:Comments=--
  2658.  
  2659. INFORMIX:Objects1=O:C:0M::"Tables":Table
  2660. INFORMIX:Objects2=O:C:0M::"Views":View
  2661. INFORMIX:Objects3=O:C:0M::"Synonyms":Synonym
  2662. INFORMIX:Objects4=O:C:0M::"Procedures":Procedure
  2663.  
  2664. informix.systables:Key=tabid
  2665. informix.systables:Name=owner,tabname
  2666. informix.systables:Attrs1=created="Created"
  2667. informix.systables:Attrs2=locklevel="Lock Mode":2::::VM=TLockMode
  2668. informix.systables:Attrs3=fextsize="Initial Extent (K)":2
  2669. informix.systables:Attrs4=nextsize="Extent (K)":2
  2670. informix.systables:Attrs5=rowsize="Row Size":2
  2671. informix.systables:Attrs6=nrows="Rows":2
  2672. informix.systables:Attrs7=npused="Pages":2
  2673.  
  2674. informix.sysconstraints:Key=tabid,constrid
  2675. informix.sysconstraints:Name=owner,constrname
  2676.  
  2677. informix.sysindexes:Key=tabid,owner,idxname
  2678. informix.sysindexes:Name=owner,idxname
  2679. informix.sysindexes:Attrs1=idxtype="Unique"::E:::VM=TUnique
  2680. informix.sysindexes:Attrs2=clustered="Clustered"::E:::VM=TClustered
  2681. informix.sysindexes:Attrs3=levels="Levels":2,leaves="Leaves":2
  2682. informix.sysindexes:Attrs4=clust="Clustering Factor":2
  2683.  
  2684. informix.sysprocedures:Key=procid
  2685. informix.sysprocedures:Name=owner,procname
  2686. informix.sysprocedures:Attrs1=mode="Mode":::::VM=TMode
  2687. informix.sysprocedures:Attrs2=codesize="Code Size"
  2688. informix.sysprocedures:Attrs3=datasize="Data Size"
  2689. informix.sysprocedures:Attrs4=retsize="Values Size":2
  2690. informix.sysprocedures:Attrs5=symsize="Symbols Size":2
  2691.  
  2692. Table:Definition=Root=informix.systables
  2693. View:Definition=Root=informix.systables
  2694. Synonym:Definition=Root=informix.systables
  2695. Index:Definition=Root=informix.sysindexes
  2696. PrimaryKey:Definition=Root=informix.sysconstraints
  2697. ForeignKey:Definition=Root=informix.sysconstraints
  2698. UniqueConstraint:Definition=Root=informix.sysconstraints
  2699. CheckConstraint:Definition=Root=informix.sysconstraints
  2700. Procedure:Definition=Root=informix.sysprocedures
  2701.  
  2702. Table:Category=Dataset
  2703. Table:Values=A.tabtype = 'T'
  2704. Table:Objects1=Q:P:1M::"Columns":Column
  2705. Table:Objects2=T:O:0M::"Indices":Index
  2706. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  2707. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  2708. Table:Objects5=T:O:0M::"Unique Constraints":UniqueConstraint
  2709. Table:Objects6=T:O:0M::"Check Constraints":CheckConstraint
  2710. Table:Attrs:R=locklevel::::E,fextsize::::E,nextsize::::E
  2711. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *]\N`
  2712. Table:Warning=DataLoss
  2713. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2714. Table:Text:Get1=CREATE TABLE `N` (`{>Column}*`)
  2715. Table:Text:Get2=`! ' EXTENT SIZE ' =fextsize``! ' NEXT SIZE ' =nextsize`
  2716. Table:Text:Get3=`! ' LOCK MODE ' =locklevel`
  2717. Table:Delete:Text=DROP TABLE `O`
  2718. Table:Rename:Text=RENAME TABLE `O` TO `N1`
  2719.  
  2720. View:Category=Dataset
  2721. View:Values=A.tabtype = 'V'
  2722. View:Objects=Q:P:0M:NMDR:"Columns":Column
  2723. View:Attrs:Q=Text=String::"Text"::ER
  2724. View:AttrReference:Text1=select viewtext, seqno from informix.sysviews
  2725. View:AttrReference:Text2=where tabid=`:tabid` order by seqno
  2726. View:Warning=Loss
  2727. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2728. View:Text:Init=CREATE VIEW `EDefaultName` AS SELECT
  2729. View:Text:Get=`=Text`
  2730. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  2731. View:Text:NameSet=1=`N`
  2732. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  2733. View:Text:Set=Text=0,*N=2
  2734. View:Delete:Text=DROP VIEW `O`
  2735.  
  2736. Synonym:Category=Dataset
  2737. Synonym:Values=A.tabtype IN ('P', 'S')
  2738. Synonym:Objects=P:R:M1::"Local Target":Table
  2739. Synonym:Attrs:T1=informix.syssyntable.servername=SName:"Server":::E
  2740. Synonym:Attrs:T2=informix.syssyntable.dbname=SDatabase:"Database":::E
  2741. Synonym:Attrs:T3=informix.syssyntable.owner=SOwner:"Owner":::E
  2742. Synonym:Attrs:T4=informix.syssyntable.tabname=STable:"Table":::E
  2743. Synonym:Attrs:T5=informix.syssyntable.btabid=TargetId:::0
  2744. Synonym:Attrs:R=Table::::E
  2745. Synonym:AttrReference:SName=tabid=tabid
  2746. Synonym:AttrReference:SDatabase=tabid=tabid
  2747. Synonym:AttrReference:SOwner=tabid=tabid
  2748. Synonym:AttrReference:STable=tabid=tabid
  2749. Synonym:AttrReference:TargetId=tabid=tabid
  2750. Synonym:Reference:"Local Target"=TargetId
  2751. Synonym:Warning=Loss
  2752. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2753. Synonym:Text:Get1=CREATE SYNONYM `N` FOR
  2754. Synonym:Text:Get2=`!=SName'@'``!=SDatabase'.'``!=SOwner'.'``=STable``=Table`
  2755. Synonym:Text:RE=CREATE\_+SYNONYM\_+(\w+)
  2756. Synonym:Text:Set=*N=1
  2757. Synonym:Delete:Text=DROP SYNONYM `O`
  2758.  
  2759. Column:Definition1=Dataset=
  2760. Column:Definition2=SELECT tabid,colno,colname,collength as Length,colmin,colmax,
  2761. Column:Definition3=coltype-trunc(coltype/256)*256 as Type,trunc(coltype/256) as Null
  2762. Column:Definition4=FROM informix.syscolumns WHERE tabid=`=tabid`
  2763. Column:Dataset1=tabid=Integer,colname=String,colno=Word,Length=Integer
  2764. Column:Dataset2=colmin=Integer,colmax=Integer,Type=Word,Null=Word
  2765. Column:Category=Column
  2766. Column:Key=tabid,colno
  2767. Column:Name=colname
  2768. Column:Order=colno
  2769. Column:Attrs1=colno="Order":2:ER
  2770. Column:Attrs2=Type="Type"::ER:::VM=TDataType
  2771. Column:Attrs3=Length="Length"::E
  2772. Column:Attrs4=Null="Nulls"::E:::VM=TNull01
  2773. Column:EAttrs=Text,New,Delete,Modify,Rename
  2774. Column:Text:Get=`N ' ' EType``! ' ' =Null`
  2775.  
  2776. Index:Category=Index
  2777. Index:Objects=M:P:1M::"Columns":IndexColumn:GetIndexColumns
  2778. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  2779. Index:Text:Get1=CREATE `=idxtype``! ' ' =clustered` INDEX `N`
  2780. Index:Text:Get2=ON `{<}N` (`{>IndexColumn}*`)
  2781. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  2782. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  2783. Index:Delete:Text=DROP INDEX `O`
  2784. Index:Reference:"Columns":Text=`[IndexColumn:%s,%s:\N '  ' *]`
  2785.  
  2786. IndexColumn:Category=ColumnReference
  2787. IndexColumn:Definition=Dataset
  2788. IndexColumn:Dataset=ItemNo=Integer,ColNo=Integer,Descending=Integer
  2789. IndexColumn:Name=Column
  2790. IndexColumn:Order=ItemNo
  2791. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2792. IndexColumn:Attrs1=ItemNo="Order":2:ER
  2793. IndexColumn:Attrs2=Descending="Descending"::E:::VM=TDescending
  2794. IndexColumn:Attrs:R=Column::Descending:2:ER
  2795. IndexColumn:Reference:"Column"=,ColNo
  2796. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  2797. IndexColumn:Text:Get=`N ' ' =Descending`
  2798.  
  2799. KeyColumn:Category=ColumnReference
  2800. KeyColumn:Definition=Dataset
  2801. KeyColumn:Dataset=ItemNo=Integer,ColNo=Integer,Descending=Integer
  2802. KeyColumn:Name=Column
  2803. KeyColumn:Order=ItemNo
  2804. KeyColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  2805. KeyColumn:Attrs1=ItemNo="Order":2:ER
  2806. KeyColumn:Attrs:R=Column::Descending:2:ER
  2807. KeyColumn:Reference:"Column"=,ColNo
  2808. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  2809. KeyColumn:Text:Get=`N`
  2810.  
  2811. PrimaryKey:Category=PrimaryKey
  2812. PrimaryKey:Values=A.constrtype = 'P'
  2813. PrimaryKey:Objects1=P:R:M1::"Index":Index:<>Index
  2814. PrimaryKey:Objects2=M:P:1M::"Columns":IndexColumn:GetKeyColumns
  2815. PrimaryKey:Reference:"Index"=owner=owner,idxname=idxname
  2816. PrimaryKey:Reference:"Columns":Text=`[IndexColumn:%s,%s:N]`
  2817. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2818. PrimaryKey:Text:Init1=ALTER TABLE `{<}N\N` ADD CONSTRAINT `\N`
  2819. PrimaryKey:Text:Init2=PRIMARY KEY (`{>IndexColumn}*`) `\N`
  2820. PrimaryKey:Text:Init3=CONSTRAINT `EDefaultName`
  2821. PrimaryKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `\N`
  2822. PrimaryKey:Text:Get2=PRIMARY KEY (`{>IndexColumn}*`) `\N`
  2823. PrimaryKey:Text:Get3=CONSTRAINT `N`
  2824. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2825.  
  2826. ForeignKey:Category=ForeignKey
  2827. ForeignKey:Values=A.constrtype = 'R'
  2828. ForeignKey:Objects1=P:R:M1::"Index":Index:<>Index
  2829. ForeignKey:Objects2=M:P:1M::"Columns":IndexColumn:GetKeyColumns
  2830. ForeignKey:Objects3=P:R:M1::"Reference Table":Table
  2831. ForeignKey:Attrs:T1=informix.sysreferences.ptabid=ReferenceTable:::0
  2832. ForeignKey:Attrs:T2=informix.sysreferences.primary=ReferenceConstraint:::0
  2833. ForeignKey:Attrs:R=Table::::ER
  2834. ForeignKey:Reference:"Index"=owner=owner,idxname=idxname
  2835. ForeignKey:Reference:"Columns":Text=`[IndexColumn:%s,%s:N]`
  2836. ForeignKey:Reference:"Reference Table"=ReferenceTable
  2837. ForeignKey:AttrReference:ReferenceTable=constrid=constrid
  2838. ForeignKey:AttrReference:ReferenceConstraint=constrid=constrid
  2839. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  2840. ForeignKey:Text:Init1=ALTER TABLE `{<}N\N` ADD CONSTRAINT `\N`
  2841. ForeignKey:Text:Init2=FOREIGN KEY (`{>IndexColumn}*`)
  2842. ForeignKey:Text:Init3=REFERENCES `=Table \N`
  2843. ForeignKey:Text:Init4=CONSTRAINT `EDefaultName`
  2844. ForeignKey:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `\N`
  2845. ForeignKey:Text:Get2=FOREIGN KEY (`{>IndexColumn}*`) `\N`
  2846. ForeignKey:Text:Get3=REFERENCES `=Table \N`
  2847. ForeignKey:Text:Get4=CONSTRAINT `N`
  2848. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2849.  
  2850. CheckConstraint:Category=Expression
  2851. CheckConstraint:Values=A.constrtype = 'C'
  2852. CheckConstraint:Attrs:Q=Text=String::"Constraint Text":2:ER:PStripParens
  2853. CheckConstraint:AttrReference:Text1=select checktext, seqno from "informix".syschecks
  2854. CheckConstraint:AttrReference:Text2=where constrid=`:constrid` and type='T'
  2855. CheckConstraint:AttrReference:Text3=order by seqno
  2856. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2857. CheckConstraint:Text:Init1=ALTER TABLE `{<}N\N` ADD CONSTRAINT `\N`
  2858. CheckConstraint:Text:Init2=CHECK () `\N`
  2859. CheckConstraint:Text:Init3=CONSTRAINT `EDefaultName`
  2860. CheckConstraint:Text:Get1=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `\N`
  2861. CheckConstraint:Text:Get2=CHECK (`=Text`) `\N`
  2862. CheckConstraint:Text:Get3=CONSTRAINT `N`
  2863. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+CHECK\_*\((.*)\)\_+CONSTRAINT\_+(\w+)
  2864. CheckConstraint:Text:Set=1=`{<}N`,Text=2,*N=3
  2865. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2866.  
  2867. UniqueConstraint:Category=UniqueConstraint
  2868. UniqueConstraint:Values=A.constrtype = 'U'
  2869. UniqueConstraint:Objects1=P:R:M1::"Index":Index:<>Index
  2870. UniqueConstraint:Objects2=M:P:1M::"Columns":IndexColumn:GetKeyColumns
  2871. UniqueConstraint:Reference:"Index"=owner=owner,idxname=idxname
  2872. UniqueConstraint:Reference:"Columns":Text=`[IndexColumn:%s,%s:N]`
  2873. UniqueConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  2874. UniqueConstraint:Text:Init1=ALTER TABLE `{<}N\N` ADD CONSTRAINT `\N`
  2875. UniqueConstraint:Text:Init2=UNIQUE (`{>IndexColumn}*`) `\N`
  2876. UniqueConstraint:Text:Init3=CONSTRAINT `EDefaultName`
  2877. UniqueConstraint:Text:Get1=ALTER TABLE `{<}N` ADD CONSTRAINT `\N`
  2878. UniqueConstraint:Text:Get2=UNIQUE (`{>IndexColumn}*`) `\N`
  2879. UniqueConstraint:Text:Get3=CONSTRAINT `N`
  2880. UniqueConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  2881.  
  2882. Procedure:Category=Executable
  2883. Procedure:Attrs:Q=Text=Memo::"Text"::ER
  2884. Procedure:AttrReference:Text1=select data, datakey, seqno from informix.sysprocbody
  2885. Procedure:AttrReference:Text2=where procid=`:procid` and datakey='T'
  2886. Procedure:AttrReference:Text3=order by datakey, seqno
  2887. Procedure:Warning=Loss
  2888. Procedure:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  2889. Procedure:Text:Init=CREATE PROCEDURE `EDefaultName`
  2890. Procedure:Text:Get=`=Text`
  2891. Procedure:Text:NameRE=Text:PROCEDURE\_(\_*\w+)
  2892. Procedure:Text:NameSet=1=`N`
  2893. Procedure:Text:RE=CREATE(\_+DBA)?\_+PROCEDURE\_+(\w+).*
  2894. Procedure:Text:Set=Text=0,*N=2
  2895. Procedure:Delete:Text=DROP PROCEDURE `O`
  2896.  
  2897.  
  2898.  
  2899. [DB2 Common Server Properties]
  2900. TBooleanNY:Values=Closed,N=:"No",Y=:"Yes"
  2901. TBoolean01:Values=Closed,0=:"No",1=:"Yes"
  2902. TUpdateStatistics:Values=Closed,-1=
  2903. TNullNY:Values=Closed,N=NOT NULL:"No",Y=:"Yes"
  2904. TLoggedNY:Values=Closed,N=NOT LOGGED:"No",Y=LOGGED:"Yes"
  2905. TCompactNY:Values=Closed,N=NOT COMPACT:"No",Y=COMPACT:"Yes"
  2906. TDescending:Values=Closed,+=ASC:"No",-=DESC:"Yes"
  2907. TTypeKind:Values=Closed,S=:"System",T=:"Distinct"
  2908. TTypeId:Values1=Closed,124=BLOB,112=BOOLEAN,60=CHARACTER,44=CLOB,100=DATE,16=DECIMAL
  2909. TTypeId:Values2=8=DOUBLE,24=INTEGER,52=LONG VARCHAR,28=SMALLINT,104=TIME
  2910. TTypeId:Values3=108=TIMESTAMP,56=VARCHAR
  2911. TFunctionKind:Values=Closed,B=:"Built-in",E=:"External",U=:"Derived External",S=:"Generated"
  2912. TFunctionScalar:Values=Closed,C=:"No",S=:"Yes"
  2913. TVariantNY:Values=Closed,N=NOT VARIANT:"No",Y=VARIANT:"Yes"
  2914. TFencedNY:Values=Closed,N=NOT FENCED:"No",Y=FENCED:"Yes"
  2915. TNullCallNY:Values=Closed,N=NOT NULL CALL:"No",Y=NULL CALL:"Yes"
  2916. TExternalActionNY:Values=Closed,N=NO EXTERNAL ACTION:"No",E=EXTERNAL ACTION:"Yes"
  2917. TScratchPadNY:Values=Closed,N=NO SCRATCHPAD:"No",Y=SCRATCHPAD:"Yes"
  2918. TFinalCallNY:Values=Closed,N=NO FINAL CALL:"No",Y=FINAL CALL:"Yes"
  2919. TUnique:Values=Closed,D=:"No",U=UNIQUE:"Yes"
  2920. TValid:Values=Closed,N=:"No",Y=:"Yes",X=:"Rebind"
  2921. TDTFormat:Values=Closed,0=:"Country Code",1=:"USA",2=:"EUR",3=:"ISO",4=:"JIS",5="Local"
  2922. TIsolation:Values1=Closed,RR=:"Repeatable Read",RS=:"Read Stability"
  2923. TIsolation:Values2=CS=:"Cursor Stability",UR=:"Uncommitted Read"
  2924. TCursorBlocking:Values=Closed,N=:"No",U=:"Unambiguous",B=:"All"
  2925. TLanguageLevel:Values=Closed,0=SAA1,1=MIA
  2926. TExplainLevel:Values=Closed,A="All",P="Package"
  2927. TRule:Values1=Closed,A=NO ACTION:"No Action",C=CASCADE:"Cascade"
  2928. TRule:Values2=N=SET NULL:"Set Null",R=RESTRICT:"Restrict"
  2929. TTableStatus:Values=Closed,N=,C=:"Check pending",X=:"Inoperative"
  2930. TDataCaptureNY:Values=Closed,N=NONE:"No",Y=CHANGES:"Yes"
  2931. TTableSpaceType:Values1=Closed,S=SYSTEM USING ('filepath'):"System"
  2932. TTableSpaceType:Values2=D=DATABASE USING (DEVICE 'devicepath' size):"Database"
  2933. TTableSpaceData:Values=Closed,A=REGULAR:"All Permanent",L=LONG:"Long Data",T=TEMPORARY:"Temporary"
  2934. TTriggerValid:Values=Closed,X=:"No",Y=:"Yes"
  2935. TTriggerOrder:Values=Closed,B=:"Before",A=:"After"
  2936. TTriggerEvent:Values=Closed,I=:"On Insert",D=:"On Delete",U=:"On Update"
  2937. TTriggerGranularity:Values=Closed,S=:"Statement",R=:"Row"
  2938. TViewCheck:Values=Closed,N=,L=:"Local",C=:"Cascade"
  2939.  
  2940. DB2:UserName=select distinct user from syscat.datatypes
  2941. DB2:Comments=--
  2942.  
  2943. DB2:Objects1=O:C:0M::"Data Types":Type
  2944. DB2:Objects2=O:C:0M::"Tables":Table
  2945. DB2:Objects3=O:C:0M::"Views":View
  2946. DB2:Objects4=O:C:0M::"TableSpaces":TableSpace
  2947. DB2:Objects4=O:C:0M::"Aliases":Synonym
  2948. DB2:Objects5=O:C:0M::"Packages":Package
  2949. DB2:Objects6=O:C:0M::"Functions":Function
  2950.  
  2951. SYSCAT.CHECKS:Key=TABSCHEMA,TABNAME,CONSTNAME
  2952. SYSCAT.CHECKS:Name=CONSTNAME
  2953. SYSCAT.CHECKS:Attrs1=DEFINER="Owner"
  2954. SYSCAT.CHECKS:Attrs2=CREATE_TIME="Created"
  2955. SYSCAT.CHECKS:Attrs3=FUNC_PATH="Function Path":2
  2956. SYSCAT.CHECKS:Attrs4=TEXT="Constraint Text":2:ER
  2957.  
  2958. SYSCAT.COLCHECKS:Key=TABSCHEMA,TABNAME,CONSTNAME
  2959. SYSCAT.COLCHECKS:Name=CONSTNAME
  2960.  
  2961. SYSCAT.COLUMNS:Key=TABSCHEMA,TABNAME,COLNAME
  2962. SYSCAT.COLUMNS:Name=COLNAME
  2963. SYSCAT.COLUMNS:Order=COLNO
  2964. SYSCAT.COLUMNS:Objects=P:R:M1::"Type":Type
  2965. SYSCAT.COLUMNS:Attrs1=COLNO="Order":2:ER
  2966. SYSCAT.COLUMNS:Attrs2=LENGTH=Length="Length"::E
  2967. SYSCAT.COLUMNS:Attrs3=SCALE=Scale="Scale"::E
  2968. SYSCAT.COLUMNS:Attrs4=NULLS=Null="Nulls"::E:::VM=TNullNY
  2969. SYSCAT.COLUMNS:Attrs5=DEFAULT=Default="Default":2:E
  2970. SYSCAT.COLUMNS:Attrs6=LOGGED="Logged":2:E:::VM=TLoggedNY
  2971. SYSCAT.COLUMNS:Attrs7=COMPACT="Compacted":2:E:::VM=TCompactNY
  2972. SYSCAT.COLUMNS:Attrs8=CODEPAGE="Code Page":2
  2973. SYSCAT.COLUMNS:Attrs9=REMARKS="Comments":2
  2974. SYSCAT.COLUMNS:Reference:"Type"=TYPESCHEMA,TYPENAME
  2975.  
  2976. SYSCAT.DATATYPES:Name=TYPESCHEMA,TYPENAME
  2977. SYSCAT.DATATYPES:Attrs1=DEFINER="Owner"
  2978. SYSCAT.DATATYPES:Attrs2=METATYPE="Kind":::::VM=TTypeKind
  2979. SYSCAT.DATATYPES:Attrs3=LENGTH=Length="Length"::E
  2980. SYSCAT.DATATYPES:Attrs4=SCALE=Scale="Scale"::E
  2981. SYSCAT.DATATYPES:Attrs5=CREATE_TIME="Created"
  2982. SYSCAT.DATATYPES:Attrs6=CODEPAGE="Code Page":2
  2983. SYSCAT.DATATYPES:Attrs7=REMARKS="Comments":2
  2984.  
  2985. SYSCAT.FUNCPARMS:Key=FUNCSCHEMA,SPECIFICNAME,ORDINAL
  2986. SYSCAT.FUNCPARMS:Name=ORDINAL
  2987. SYSCAT.FUNCPARMS:Objects=P:R:M1::"Type":Type
  2988. SYSCAT.FUNCPARMS:Attrs1=LENGTH=Length="Length"::E
  2989. SYSCAT.FUNCPARMS:Attrs2=SCALE=Scale="Scale"::E
  2990. SYSCAT.FUNCPARMS:Attrs3=CODEPAGE="Code Page":2
  2991. SYSCAT.FUNCPARMS:Reference:"Type"=TYPESCHEMA,TYPENAME
  2992.  
  2993. SYSCAT.FUNCTIONS:Key=FUNCSCHEMA,SPECIFICNAME
  2994. SYSCAT.FUNCTIONS:Name=FUNCSCHEMA,SPECIFICNAME
  2995. SYSCAT.FUNCTIONS:Objects1=T:P:0M::"Parameters":FunctionParameter
  2996. SYSCAT.FUNCTIONS:Objects2=T:P:0M::"Result":Result
  2997. SYSCAT.FUNCTIONS:Attrs1=FUNCNAME="Function"
  2998. SYSCAT.FUNCTIONS:Attrs2=DEFINER="Owner"
  2999. SYSCAT.FUNCTIONS:Attrs3=ORIGIN="Origin":::::VM=TFunctionKind
  3000. SYSCAT.FUNCTIONS:Attrs4=TYPE="Scalar":::::VM=TFunctionScalar
  3001. SYSCAT.FUNCTIONS:Attrs5=CREATE_TIME="Created"
  3002. SYSCAT.FUNCTIONS:Attrs6=LANGUAGE="Language":2
  3003. SYSCAT.FUNCTIONS:Attrs7=IMPLEMENTATION="Implementation":2
  3004. SYSCAT.FUNCTIONS:Attrs8=VARIANT="Variant":2::::VM=TVariantNY
  3005. SYSCAT.FUNCTIONS:Attrs9=SIDE_EFFECTS="Side Effects":2::::VM=TExternalActionNY
  3006. SYSCAT.FUNCTIONS:Attrs10=FENCED="Fenced":2::::VM=TFencedNY
  3007. SYSCAT.FUNCTIONS:Attrs11=NULLCALL="NullCall":2::::VM=TNullCallNY
  3008. SYSCAT.FUNCTIONS:Attrs12=CAST_FUNCTION="Cast":2::::VM=TBooleanNY
  3009. SYSCAT.FUNCTIONS:Attrs13=ASSIGN_FUNCTION="Assignment":2::::VM=TBooleanNY
  3010. SYSCAT.FUNCTIONS:Attrs14=SCRATCHPAD="ScratchPad":2::::VM=TScratchPadNY
  3011. SYSCAT.FUNCTIONS:Attrs15=FINAL_CALL="Final Call":2::::VM=TFinalCallNY
  3012. SYSCAT.FUNCTIONS:Attrs16=REMARKS="Comments":2
  3013. SYSCAT.FUNCTIONS:Reference:"Parameters":Text=`[FunctionParameter:%s,%s:*]`
  3014. SYSCAT.FUNCTIONS:Reference:"Result":Text=`[Result:%s CAST FROM %s:*]`
  3015.  
  3016. SYSCAT.INDEXES:Name=INDSCHEMA,INDNAME
  3017. SYSCAT.INDEXES:Attrs1=DEFINER="Owner"
  3018. SYSCAT.INDEXES:Attrs2=UNIQUERULE="Unique"::E:::VM=TUnique
  3019. SYSCAT.INDEXES:Attrs3=USER_DEFINED="User Defined":::::VM=TBoolean01
  3020. SYSCAT.INDEXES:Attrs4=SYSTEM_REQUIRED="System Required":::::VM=TBoolean01
  3021. SYSCAT.INDEXES:Attrs5=CREATE_TIME="Created"
  3022. SYSCAT.INDEXES:Attrs6=STATS_TIME="Last Update Statistics"
  3023. SYSCAT.INDEXES:Attrs7=REMARKS="Comments":2
  3024. SYSCAT.INDEXES:Attrs8=NLEAF="Leaf Pages":2::::VM=TUpdateStatistics
  3025. SYSCAT.INDEXES:Attrs9=NLEVELS="Index Levels":2::::VM=TUpdateStatistics
  3026. SYSCAT.INDEXES:Attrs10=FIRSTKEYCARD="Distinct First Values":2::::VM=TUpdateStatistics
  3027. SYSCAT.INDEXES:Attrs11=FULLKEYCARD="Distinct Values":2::::VM=TUpdateStatistics
  3028. SYSCAT.INDEXES:Attrs12=CLUSTERRATIO="Cluster Ratio":2::::VM=TUpdateStatistics
  3029. SYSCAT.INDEXES:Attrs13=CLUSTERFACTOR="Cluster Factor":2::::VM=TUpdateStatistics
  3030. SYSCAT.INDEXES:Attrs14=COLNAMES=:4
  3031.  
  3032. SYSCAT.KEYCOLUSE:Key=TABSCHEMA,TABNAME,CONSTNAME,COLNAME
  3033. SYSCAT.KEYCOLUSE:Name=Column
  3034. SYSCAT.KEYCOLUSE:Order=COLSEQ
  3035. SYSCAT.KEYCOLUSE:Objects1=P:R:M1::"Column":Column:<<>Column
  3036. SYSCAT.KEYCOLUSE:Attrs1=COLSEQ="Order":2:ER
  3037. SYSCAT.KEYCOLUSE:Reference:"Column"=,,COLNAME
  3038.  
  3039. SYSCAT.PACKAGES:Name=PKGSCHEMA,PKGNAME
  3040. SYSCAT.PACKAGES:Objects=Q:C:0M::"Sections":Section
  3041. SYSCAT.PACKAGES:Attrs1=BOUNDBY="Bound By"
  3042. SYSCAT.PACKAGES:Attrs2=VALID="Valid":::::VM=TValid
  3043. SYSCAT.PACKAGES:Attrs3=TOTAL_SECT="Sections"
  3044. SYSCAT.PACKAGES:Attrs4=LAST_BIND_TIME="Last Bind"
  3045. SYSCAT.PACKAGES:Attrs5=EXPLICIT_BIND_TIME="Explicit Bind"
  3046. SYSCAT.PACKAGES:Attrs6=ISOLATION="Isolation Level":2::::VM=TIsolation
  3047. SYSCAT.PACKAGES:Attrs7=BLOCKING="Cursor Blocking":2::::VM=TCursorBlocking
  3048. SYSCAT.PACKAGES:Attrs8=LANG_LEVEL="Language Level":2::::VM=TLanguageLevel
  3049. SYSCAT.PACKAGES:Attrs9=FUNC_PATH="Function Path":2
  3050. SYSCAT.PACKAGES:Attrs10=FORMAT="Date Time Format":2::::VM=TDTFormat
  3051. SYSCAT.PACKAGES:Attrs11=CODEPAGE="Code Page":2
  3052. SYSCAT.PACKAGES:Attrs12=SQLWARN="SQL Warnings On":2::::VM=TBooleanNY
  3053. SYSCAT.PACKAGES:Attrs13=QUERYOPT="Optimization Class":2
  3054. SYSCAT.PACKAGES:Attrs14=EXPLAIN_LEVEL="Explain Level":2::::VM=TExplainLevel
  3055. SYSCAT.PACKAGES:Attrs15=EXPLAIN_SNAPSHOT="Explain Snapshot Active":2::::VM=TBooleanNY
  3056. SYSCAT.PACKAGES:Attrs16=REMARKS="Comments":2
  3057.  
  3058. SYSCAT.TABCONST:Key=TABSCHEMA,TABNAME,CONSTNAME
  3059. SYSCAT.TABCONST:Name=CONSTNAME
  3060. SYSCAT.TABCONST:Attrs1=DEFINER="Owner"
  3061. SYSCAT.TABCONST:Attrs2=REMARKS="Comments":2
  3062.  
  3063. SYSCAT.REFERENCES:Key=TABSCHEMA,TABNAME,CONSTNAME
  3064. SYSCAT.REFERENCES:Name=CONSTNAME
  3065. SYSCAT.REFERENCES:Objects1=T:P:1M::"Columns":KeyColumn
  3066. SYSCAT.REFERENCES:Objects2=P:R:M1::"Reference Table":Table
  3067. SYSCAT.REFERENCES:Attrs1=DEFINER="Owner"
  3068. SYSCAT.REFERENCES:Attrs2=CREATE_TIME="Created"
  3069. SYSCAT.REFERENCES:Attrs3=REFKEYNAME="Primary Key":2
  3070. SYSCAT.REFERENCES:Attrs4=DELETERULE="Delete Rule":2:E:::VM=TRule
  3071. SYSCAT.REFERENCES:Attrs5=UPDATERULE="Update Rule":2:E:::VM=TRule
  3072. SYSCAT.REFERENCES:Reference:"Columns":Text=`[KeyColumn:%s,%s:*]`
  3073. SYSCAT.REFERENCES:Reference:"Reference Table"=REFTABSCHEMA,REFTABNAME
  3074.  
  3075. SYSCAT.TABLES:Name=TABSCHEMA,TABNAME
  3076. SYSCAT.TABLES:Attrs1=DEFINER="Owner"
  3077. SYSCAT.TABLES:Attrs2=STATUS="Status":::::VM=TTableStatus
  3078. SYSCAT.TABLES:Attrs3=CREATE_TIME="Created"
  3079.  
  3080. SYSCAT.TABLESPACES:Name=TBSPACE
  3081. SYSCAT.TABLESPACES:Attrs1=DEFINER="Owner"
  3082. SYSCAT.TABLESPACES:Attrs2=TBSPACETYPE="Type":::::VM=TTableSpaceType
  3083. SYSCAT.TABLESPACES:Attrs3=DATATYPE="Data":::::VM=TTableSpaceData
  3084. SYSCAT.TABLESPACES:Attrs4=CREATE_TIME="Created"
  3085. SYSCAT.TABLESPACES:Attrs5=EXTENTSIZE="Extent Size":2
  3086. SYSCAT.TABLESPACES:Attrs6=PREFETCHSIZE="Prefetch Size":2
  3087. SYSCAT.TABLESPACES:Attrs7=OVERHEAD="Overhead":2
  3088. SYSCAT.TABLESPACES:Attrs8=TRANSFERRATE="Transfer Rate":2
  3089. SYSCAT.TABLESPACES:Attrs9=REMARKS="Comments":2
  3090.  
  3091. SYSCAT.TRIGGERS:Name=TRIGSCHEMA,TRIGNAME
  3092. SYSCAT.TRIGGERS:Attrs1=DEFINER="Owner"
  3093. SYSCAT.TRIGGERS:Attrs2=CREATE_TIME="Created"
  3094. SYSCAT.TRIGGERS:Attrs3=VALID="Valid":::::VM=TTriggerValid
  3095. SYSCAT.TRIGGERS:Attrs4=TRIGTIME="Order":::::VM=TTriggerOrder
  3096. SYSCAT.TRIGGERS:Attrs5=TRIGEVENT="On Event":::::VM=TTriggerEvent
  3097. SYSCAT.TRIGGERS:Attrs6=GRANULARITY="Granularity":::::VM=TTriggerGranularity
  3098. SYSCAT.TRIGGERS:Attrs7=FUNC_PATH="Function Path":2
  3099. SYSCAT.TRIGGERS:Attrs8=REMARKS="Comments":2
  3100.  
  3101. SYSCAT.VIEWS:Name=VIEWSCHEMA,VIEWNAME
  3102. SYSCAT.VIEWS:Attrs1=VIEWCHECK="Check Option":::::VM=TViewCheck
  3103. SYSCAT.VIEWS:Attrs2=READONLY="Read Only":::::VM=TBooleanNY
  3104. SYSCAT.VIEWS:Attrs3=FUNC_PATH="Function Path"
  3105.  
  3106. CheckConstraint:Category=Expression
  3107. CheckConstraint:Definition=Root=SYSCAT.TABCONST
  3108. CheckConstraint:Values=A.TYPE = 'K'
  3109. CheckConstraint:Attrs:T1=SYSCAT.CHECKS.CREATE_TIME=Created::REMARKS
  3110. CheckConstraint:Attrs:T2=SYSCAT.CHECKS.FUNC_PATH=FunctionPath::REMARKS
  3111. CheckConstraint:Attrs:T3=SYSCAT.CHECKS.TEXT=Text::REMARKS
  3112. CheckConstraint:EAttrs=Text,New,Delete,Modify,Rename,Save
  3113. CheckConstraint:Text:Init=ALTER TABLE `{<}N\N` ADD CONSTRAINT `EDefaultName` CHECK ()
  3114. CheckConstraint:Text:Get=ALTER TABLE `{<}N\N`  ADD CONSTRAINT `N\N`  CHECK (`=Text`)
  3115. CheckConstraint:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+CHECK\_*\((.*)\)
  3116. CheckConstraint:Text:Set=1=`{<}N`,*N=2,Text=3
  3117. CheckConstraint:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  3118.  
  3119. Column:Category=Column
  3120. Column:Definition=Root=SYSCAT.COLUMNS
  3121. Column:Attrs:R=Type:"Type":"Length":1:ER
  3122. Column:EAttrs=Text,New,Delete,Modify,Rename
  3123. Column:Text:Get=`N` `EType``! ' ' =Null``! ' WITH DEFAULT ' =Default``! ' ' =LOGGED``! ' ' =COMPACT`
  3124. Column:New:Text=ALTER TABLE `{<}N` ADD COLUMN `*`
  3125.  
  3126. Type:Category=Type
  3127. Type:Definition=Root=SYSCAT.DATATYPES
  3128. Type:Objects=P:R:M1::"Base Type":Type
  3129. Type:Attrs:R=Type::"Length":1:ER
  3130. Type:Warning=Loss
  3131. Type:EAttrs=Text,New,Delete,Modify,Rename,Save
  3132. Type:Reference:"Base Type"=SOURCESCHEMA,SOURCENAME
  3133. Type:Text:Init=CREATE DISTINCT TYPE `EDefaultName` AS `EType`
  3134. Type:Text:Get=CREATE DISTINCT TYPE `N` AS `EType`
  3135. Type:Delete:Text=DROP DISTINCT TYPE `O`
  3136.  
  3137. FunctionParameter:Category=Column
  3138. FunctionParameter:Definition=Root=SYSCAT.FUNCPARMS
  3139. FunctionParameter:Values=A.ROWTYPE = 'P'
  3140. FunctionParameter:Order=ORDINAL
  3141. FunctionParameter:Attrs1=ORDINAL="Order":2:ER
  3142. FunctionParameter:EAttrs=Text
  3143. FunctionParameter:Text:Get=`EType`
  3144.  
  3145. Result:Category=Column
  3146. Result:Definition=Root=SYSCAT.FUNCPARMS
  3147. Result:Values=A.ROWTYPE IN ('R', 'C')
  3148. Result:EAttrs=Text
  3149. Result:Text:Get=`EType`
  3150.  
  3151. Function:Category=Executable
  3152. Function:Definition=Root=SYSCAT.FUNCTIONS
  3153. Function:Objects=P:R:M1::"Source":Function
  3154. Function:Warning=Loss
  3155. Function:EAttrs=Text
  3156. Function:Text:Get1=CREATE FUNCTION `=FUNCNAME` (`{>FunctionParameter}*`)`\N ' '`
  3157. Function:Text:Get2=`' RETURNS ' {>Result}*` SPECIFIC `N``\N '  '`
  3158. Function:Text:Get3=`!'EXTERNAL NAME ' \Q =IMPLEMENTATION \Q`
  3159. Function:Text:Get4=`!' LANGUAGE ' =LANGUAGE ' PARAMETER STYLE DB2SQL ' =VARIANT ' ' =FENCED ' ' =NULLCALL ' NO SQL ' =SIDE_EFFECTS ' ' =SCRATCHPAD ' ' =FINAL_CALL`
  3160. Function:Text:Get5=`!'SOURCE SPECIFIC ' =Function`
  3161. Function:Delete:Text=DROP SPECIFIC FUNCTION `O`
  3162.  
  3163. Index:Category=Index
  3164. Index:Definition=Root=SYSCAT.INDEXES
  3165. Index:Objects=M:P:1M::"Columns":IndexColumn:GetIndexColumns
  3166. Index:Values=A.UNIQUERULE <> 'P'
  3167. Index:EAttrs=Text,New,Delete,Modify,Rename,Save
  3168. Index:Text:Get1=CREATE `=UNIQUERULE` INDEX `N`
  3169. Index:Text:Get2=ON `{<}N` (`{>IndexColumn}*`)
  3170. Index:Text:RE=CREATE.*\_INDEX\_+(\w+)\_+ON\_+(\w+).*(\(.*\))
  3171. Index:Text:Set=*N=1,2=`{<}N`,*>IndexColumn=3
  3172. Index:Delete:Text=DROP INDEX `O`
  3173. Index:Reference:"Columns":Text=`[IndexColumn:%s,%s:*]`
  3174.  
  3175. IndexColumn:Category=ColumnReference
  3176. IndexColumn:Definition=Dataset
  3177. IndexColumn:Dataset1=ItemNo=Integer,ColName=String,Descending=String:1
  3178. IndexColumn:Name=Column
  3179. IndexColumn:Order=ItemNo
  3180. IndexColumn:Objects1=P:R:M1::"Column":Column:<<>Column
  3181. IndexColumn:Attrs1=ItemNo="Order":2:ER
  3182. IndexColumn:Attrs2=Descending="Descending"::E:::VM=TDescending
  3183. IndexColumn:Attrs:R=Column::Descending:2:ER
  3184. IndexColumn:Reference:"Column"=,,ColName
  3185. IndexColumn:EAttrs=Text,New,Delete,Modify,Rename
  3186. IndexColumn:Text:Get=`N ' ' =Descending`
  3187.  
  3188. Package:Definition=Root=SYSCAT.PACKAGES
  3189. Package:EAttrs=Delete,Save
  3190. Package:Delete:Text=DROP PACKAGE `O`
  3191.  
  3192. Section:Key=PKGSCHEMA,PKGNAME,SECTNO
  3193. Section:Name=SECTNO
  3194. Section:Definition1=Dataset=
  3195. Section:Definition2=SELECT SECTNO FROM SYSCAT.STATEMENTS
  3196. Section:Definition3=WHERE PKGSCHEMA=`OQ0` AND PKGNAME=`OQ1`
  3197. Section:Dataset=SECTNO=Integer
  3198. Section:Objects=Q:C:0M::"Statements":Statement
  3199. Section:EAttrs=
  3200.  
  3201. Statement:Name=STMTNO
  3202. Statement:Definition1=Dataset=
  3203. Statement:Definition2=SELECT STMTNO FROM SYSCAT.STATEMENTS
  3204. Statement:Definition3=WHERE PKGSCHEMA=`{<}OQ0` AND PKGNAME=`{<}OQ1` AND
  3205. Statement:Definition4=SECTNO=`:SECTNO`
  3206. Statement:Dataset=STMTNO=Integer
  3207. Statement:Attrs:Q=Text=Memo::"Text"
  3208. Statement:EAttrs=Text
  3209. Statement:Text:Get=`=Text`
  3210. Statement:AttrReference:Text1=SELECT TEXT, SEQNO FROM SYSCAT.STATEMENTS
  3211. Statement:AttrReference:Text2=WHERE PKGSCHEMA=`{<<}OQ0` AND PKGNAME=`{<<}OQ1`
  3212. Statement:AttrReference:Text3=AND SECTNO=`{<}:SECTNO` AND STMTNO=`:STMTNO`
  3213. Statement:AttrReference:Text4=ORDER BY SEQNO
  3214.  
  3215. PrimaryKey:Category=PrimaryKey
  3216. PrimaryKey:Definition=Root=SYSCAT.TABCONST
  3217. PrimaryKey:Values=A.TYPE = 'P'
  3218. PrimaryKey:Objects=T:P:1M::"Columns":KeyColumn
  3219. PrimaryKey:Reference:"Columns":Text=`[KeyColumn:%s,%s:*]`
  3220. PrimaryKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  3221. PrimaryKey:Text:Init1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `EDefaultName \N '  '`
  3222. PrimaryKey:Text:Init2=PRIMARY KEY (`{>KeyColumn}*`)
  3223. PrimaryKey:Text:Get1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `N \N '  '`
  3224. PrimaryKey:Text:Get2=PRIMARY KEY (`{>KeyColumn}*`)
  3225. PrimaryKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  3226.  
  3227. ForeignKey:Category=ForeignKey
  3228. ForeignKey:Definition=Root=SYSCAT.REFERENCES
  3229. ForeignKey:Attrs:T=SYSCAT.TABCONST.REMARKS=Comments
  3230. ForeignKey:Attrs:R=Table::::ER
  3231. ForeignKey:EAttrs=Text,New,Delete,Modify,Rename,Save
  3232. ForeignKey:Text:Init1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `EDefaultName`
  3233. ForeignKey:Text:Init2=`\N`  FOREIGN KEY (`{>KeyColumn}*`) REFERENCES `=Table`
  3234. ForeignKey:Text:Init3=`\N`  ON DELETE RESTRICT ON UPDATE RESTRICT
  3235. ForeignKey:Text:Get1=ALTER TABLE `{<}N \N '  '`ADD CONSTRAINT `N`
  3236. ForeignKey:Text:Get2=`\N`  FOREIGN KEY (`{>KeyColumn}*`) REFERENCES `=Table \N`
  3237. ForeignKey:Text:Get3= ON DELETE `=DELETERULE \N '  '`ON UPDATE `=UPDATERULE`
  3238. ForeignKey:Text:RE=ALTER\_+TABLE\_+(\w+)\_+ADD\_+CONSTRAINT\_+(\w+)\_+.*REFERENCES\_+(\w+)?.*\_ON\_+DELETE\_+(.*)\_ON\_+UPDATE\_+(.*)
  3239. ForeignKey:Text:Set=1=`{<}N`,*N=2,Table=3,DELETERULE=4,UPDATERULE=5
  3240. ForeignKey:Delete:Text=ALTER TABLE `{<}O` DROP CONSTRAINT `O`
  3241.  
  3242. KeyColumn:Category=ColumnReference
  3243. KeyColumn:Definition=Root=SYSCAT.KEYCOLUSE
  3244. KeyColumn:Attrs:R=Column:::2:ER
  3245. KeyColumn:EAttrs=Text,New,Delete,Modify,Rename
  3246. KeyColumn:Text:Get=`N`
  3247.  
  3248. Table:Category=Dataset
  3249. Table:Definition=Root=SYSCAT.TABLES
  3250. Table:Values=A.TYPE = 'T'
  3251. Table:Objects1=T:P:1M::"Columns":Column
  3252. Table:Objects2=T:O:0M::"Indices":Index
  3253. Table:Objects3=T:O:01::"Primary Key":PrimaryKey
  3254. Table:Objects4=T:O:0M::"Referential Constraints":ForeignKey
  3255. Table:Objects5=T:O:0M::"Check Constraints":CheckConstraint
  3256. Table:Objects6=T:O:0M::"Triggers":Trigger
  3257. Table:Objects7=P:R:M1::"Table Space":TableSpace
  3258. Table:Objects8=P:R:M1::"Index Space":TableSpace
  3259. Table:Objects9=P:R:M1::"Long Space":TableSpace
  3260. Table:Attrs1=DATACAPTURE="Data Capture":2:E:::VM=TDataCaptureNY
  3261. Table:Attrs2=STATS_TIME="Update Statistics":2
  3262. Table:Attrs3=CARD="Row Count":2::::VM=TUpdateStatistics
  3263. Table:Attrs4=NPAGES="Used Pages":2::::VM=TUpdateStatistics
  3264. Table:Attrs5=FPAGES="Total Pages":2::::VM=TUpdateStatistics
  3265. Table:Attrs6=OVERFLOW="Overflow Rows":2::::VM=TUpdateStatistics
  3266. Table:Attrs7=REMARKS="Comments":2
  3267. Table:Attrs:R1="Table Space"::::E
  3268. Table:Attrs:R2="Index Space"::::E
  3269. Table:Attrs:R3="Long Space"::::E
  3270. Table:Warning=DataLoss
  3271. Table:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  3272. Table:Reference:"Columns":Text=`[Column:%s,%s:\N '  ' *]\N`
  3273. Table:Reference:"Indices"=TABSCHEMA=TABSCHEMA,TABNAME=TABNAME
  3274. Table:Reference:"Triggers"=TABSCHEMA=TABSCHEMA,TABNAME=TABNAME
  3275. Table:Reference:"Table Space"=TBSPACE
  3276. Table:Reference:"Index Space"=INDEX_TBSPACE
  3277. Table:Reference:"Long Space"=LONG_TBSPACE
  3278. Table:Text:Get1=CREATE TABLE `N` (`{>Column}*`)
  3279. Table:Text:Get2=`!\N'  DATA CAPTURE ' =DATACAPTURE`
  3280. Table:Text:Get3=`!\N'  IN ' ="Table Space"`
  3281. Table:Text:Get4=`!\N'  INDEX IN ' ="Index Space"`
  3282. Table:Text:Get5=`!\N'  LONG IN ' ="Long Space"`
  3283. Table:Delete:Text=DROP TABLE `O`
  3284.  
  3285. TableSpace:Definition=Root=SYSCAT.TABLESPACES
  3286. TableSpace:Warning=Loss
  3287. TableSpace:EAttrs=Text
  3288. TableSpace:Text:Get1=CREATE `=DATATYPE` TABLESPACE `N\N`
  3289. TableSpace:Text:Get2=MANAGED BY `=TBSPACETYPE`
  3290. TableSpace:Text:Get3=`! ' EXTENTSIZE ' =EXTENTSIZE`
  3291. TableSpace:Text:Get4=`! ' PREFETCHSIZE ' =PREFETCHSIZE`
  3292. TableSpace:Text:Get5=`! ' OVERHEAD ' =OVERHEAD`
  3293. TableSpace:Text:Get6=`! ' TRANSFERRATE ' =TRANSFERRATE`
  3294. TableSpace:Delete:Text=DROP TABLESPACE `O`
  3295.  
  3296. Synonym:Category=Dataset
  3297. Synonym:Definition=Root=SYSCAT.TABLES
  3298. Synonym:Values=A.TYPE = 'A'
  3299. Synonym:Attrs1=BASE_TABSCHEMA="Target Schema"
  3300. Synonym:Attrs2=BASE_TABNAME="Target Object"
  3301. Synonym:Attrs3=REMARKS="Comments":2
  3302. Synonym:Warning=Loss
  3303. Synonym:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  3304. Synonym:Text:Get1=CREATE ALIAS `N` FOR `' '`
  3305. Synonym:Text:Get2=`! '"' =BASE_TABSCHEMA '".' ``'"' =BASE_TABNAME '"'`
  3306. Synonym:Delete:Text=DROP ALIAS `O`
  3307.  
  3308. View:Category=Dataset
  3309. View:Definition=Root=SYSCAT.TABLES
  3310. View:Values=A.TYPE = 'V'
  3311. View:Objects=T:P:0M:NMDR:"Columns":Column
  3312. View:Attrs=REMARKS="Comments":2
  3313. View:Attrs:T1=SYSCAT.VIEWS.VIEWCHECK=ViewCheck
  3314. View:Attrs:T2=SYSCAT.VIEWS.READONLY=ReadOnly
  3315. View:Attrs:T3=SYSCAT.VIEWS.FUNC_PATH=FunctionPath
  3316. View:Attrs:Q=Text=Memo::"Text"::ER
  3317. View:AttrReference:Text1=SELECT TEXT, SEQNO FROM SYSCAT.VIEWS
  3318. View:AttrReference:Text2=WHERE VIEWSCHEMA=`OQ0` AND VIEWNAME=`OQ1`
  3319. View:AttrReference:Text3=ORDER BY SEQNO
  3320. View:Warning=Loss
  3321. View:EAttrs=Data,Text,New,Delete,Modify,Rename,Save
  3322. View:Text:Init=CREATE VIEW `EDefaultName` AS `\N`  SELECT * FROM "owner"."table"
  3323. View:Text:Get=`=Text`
  3324. View:Text:NameRE=Text:VIEW\_(\_*\w+)
  3325. View:Text:NameSet=1=`N`
  3326. View:Text:RE=^(.*\_)?CREATE\_+VIEW\_+(\w+)\_.*$
  3327. View:Text:Set=Text=0,*N=2
  3328. View:Delete:Text=DROP VIEW `O`
  3329.  
  3330. Trigger:Category=Executable
  3331. Trigger:Definition=Root=SYSCAT.TRIGGERS
  3332. Trigger:Attrs:Q=Text=Memo::"Text"::ER:PROOName
  3333. Trigger:AttrReference:Text1=SELECT TEXT FROM SYSCAT.TRIGGERS
  3334. Trigger:AttrReference:Text2=WHERE TRIGSCHEMA=`OQ0` AND TRIGNAME=`OQ1`
  3335. Trigger:EAttrs=Text,New,Delete,Modify,Rename,Save
  3336. Trigger:Text:Init1=CREATE TRIGGER `EDefaultName`
  3337. Trigger:Text:Init2=AFTER INSERT `\N`
  3338. Trigger:Text:Init3=ON `{<}N \N`
  3339. Trigger:Text:Init4=FOR EACH ROW  MODE DB2SQL`\N`
  3340. Trigger:Text:Init5=BEGIN ATOMIC`\N '   <statement>;' \N` END
  3341. Trigger:Text:Get=`=Text`
  3342. Trigger:Text:RE=^(.*\_)?CREATE\_+TRIGGER\_+(\w+)\_.*\_ON\_+(\w+)\_.*$
  3343. Trigger:Text:Set=*N=2,3=`{<}N`,Text=0
  3344. Trigger:Text:NameRE=Text:TRIGGER\_(\_*\w+)
  3345. Trigger:Text:NameSet=1=`N`
  3346. Trigger:Delete:Text=DROP TRIGGER `O`
  3347.  
  3348.  
  3349.