📄 dblook_test_net.out
字号:
false<systemid>-----BART4_2<systemnumber>T4_2falsenullfalse<systemid>-----BART8<systemnumber><systemname>trueBTREE (2)true<systemid>-----BART8<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>-----BART8<systemnumber>T8falsenullfalse<systemid>-----BARtWithKeys<systemnumber><systemname>trueUNIQUE BTREE (1)true<systemid>-----BARtWithKeys<systemnumber>IX3trueBTREE (1 DESC)false<systemid>-----BARtWithKeys<systemnumber>tWithKeysfalsenullfalse<systemid>-----FOOT10<systemnumber><systemname>trueUNIQUE BTREE (2)true<systemid>-----FOOT10<systemnumber><systemname>trueUNIQUE BTREE (3)true<systemid>-----FOOT10<systemnumber>T10falsenullfalse<systemid>-----FOOT9<systemnumber><systemname>trueBTREE (1)true<systemid>-----FOOT9<systemnumber><systemname>trueUNIQUE BTREE (2, 1)true<systemid>-----FOOT9<systemnumber>T9falsenullfalse<systemid>-----Foo BarT5<systemnumber>CostIndextrueUNIQUE BTREE (1)false<systemid>-----Foo BarT5<systemnumber>T5falsenullfalse<systemid>-----Foo BarT6<systemnumber>T6falsenullfalse<systemid>-----Foo BarT7<systemnumber>T7falsenullfalse<systemid>-----========== SYSCONSTRAINTS =========="ck2"tquoteTwo"ck2CAPPE0-----"effkay1"tquoteTwo"effkay1FAPPE0-----<systemname>T10<systemname>PFOOE1-----<systemname>T10<systemname>UFOOE0-----<systemname>T8<systemname>FBARE0-----<systemname>T8<systemname>PBARE0-----<systemname>tWithKeys<systemname>CBARE0-----<systemname>tWithKeys<systemname>PBARE1-----NOTEVILtWithKeysNOTEVILCBARE0-----<systemname>T11<systemname>FAPPE0-----UNQT1UNQUBARE0-----c"k1tquote"Onec"k1CAPPE0-----chkOneT10chkOneCFOOE0-----ck2"tquoteThree"ck2"CAPPE0-----fkOneT9fkOneFFOOE0-----pee"kay1tquote"Onepee"kay1PAPPE1-----pkTwoT9pkTwoPFOOE1-----<systemname>tee""Hee<systemname>P"Quoted"Schema"E0-----unqkay1"tquoteThree"unqkay1"UAPPE0-----========== SYSDEPENDS =========="effkay1<Constraint>APP."effkay1 -> <Constraint>APP.pee"kay1Constraintpee"kay1Constraint-----<systemname><Constraint>APP.<sysname> -> <Constraint>FOO.pkTwoConstraintpkTwoConstraint-----<systemname><Constraint>BAR.<sysname> -> <Constraint>BAR.<sysname>Constraint<systemname>Constraint-----fkOne<Constraint>FOO.fkOne -> <Constraint>FOO.<sysname>Constraint<systemname>Constraint-----<systemid><StoredPreparedStatement>"Quoted"Schema".<sysname> -> <Table>"Quoted"Schema".tee""HeeStoredPreparedStatementtee""HeeTable-----<systemid><StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.T4StoredPreparedStatementT4ColumnsInTable-----<systemid><StoredPreparedStatement>APP.<sysname> -> <ColumnsInTable>BAR.tWithKeysStoredPreparedStatementtWithKeysColumnsInTable-----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>APP.<sysname>StoredPreparedStatement<systemid>Conglomerate-----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.<sysname>StoredPreparedStatement<systemid>Conglomerate-----<systemid><StoredPreparedStatement>APP.<sysname> -> <Conglomerate>BAR.IX3StoredPreparedStatement<systemid>Conglomerate-----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>APP.REMOVEDStoredPreparedStatementREMOVEDTable-----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>APP.XStoredPreparedStatementXTable-----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>BAR.T3StoredPreparedStatementT3Table-----<systemid><StoredPreparedStatement>APP.<sysname> -> <Table>BAR.tWithKeysStoredPreparedStatementtWithKeysTable-----<systemid><StoredPreparedStatement>BAR.<sysname> -> <Table>BAR.T8StoredPreparedStatementT8Table-----<systemid><StoredPreparedStatement>Foo Bar.<sysname> -> <Table>BAR.T1StoredPreparedStatementT1Table-----<systemid><Trigger>"Quoted"Schema"."trig"One" -> <StoredPreparedStatement>"Quoted"Schema".<sysname>Trigger<systemid>StoredPreparedStatement-----<systemid><Trigger>"Quoted"Schema"."trig"One" -> <Table>"Quoted"Schema".tee""HeeTriggertee""HeeTable-----<systemid><Trigger>APP.TRIGFOUR -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement-----<systemid><Trigger>APP.TRIGFOUR -> <Table>APP.XTriggerXTable-----<systemid><Trigger>APP.TRIGONE -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement-----<systemid><Trigger>APP.TRIGONE -> <Table>BAR.T3TriggerT3Table-----<systemid><Trigger>APP.TrigThree -> <StoredPreparedStatement>APP.<sysname>Trigger<systemid>StoredPreparedStatement-----<systemid><Trigger>APP.TrigThree -> <Table>BAR.tWithKeysTriggertWithKeysTable-----<systemid><Trigger>BAR.REFTRIG -> <StoredPreparedStatement>BAR.<sysname>Trigger<systemid>StoredPreparedStatement-----<systemid><Trigger>BAR.REFTRIG -> <Table>BAR.T8TriggerT8Table-----<systemid><Trigger>Foo Bar.TRIG2 -> <StoredPreparedStatement>Foo Bar.<sysname>Trigger<systemid>StoredPreparedStatement-----<systemid><Trigger>Foo Bar.TRIG2 -> <Table>BAR.T1TriggerT1Table-----V1<View>APP.V1 -> <ColumnsInTable>APP.T1ViewT1ColumnsInTable-----V1<View>APP.V1 -> <ColumnsInTable>BAR.T3ViewT3ColumnsInTable-----V2<View>APP.V2 -> <ColumnsInTable>BAR.T1ViewT1ColumnsInTable-----viewTwo<View>BAR.viewTwo -> <ColumnsInTable>APP.T11ViewT11ColumnsInTable-----V1<View>FOO.V1 -> <ColumnsInTable>Foo Bar.T6ViewT6ColumnsInTable-----========== SYSFILES ==========<systemid>FOOFOOJAR<systemnumber>-----========== SYSFOREIGNKEYS ==========<systemname><systemid><systemname>UR-----"effkay1<systemid>pee"kay1RR-----fkOne<systemid><systemname>RS-----<systemname><systemid>pkTwoRR-----========== SYSKEYS ==========<systemname><systemid>-----<systemname><systemid>-----<systemname><systemid>-----<systemname><systemid>-----<systemname><systemid>-----UNQ<systemid>-----pee"kay1<systemid>-----pkTwo<systemid>-----unqkay1"<systemid>-----========== SYSSCHEMAS =========="Quoted"Schema""Quoted"Schema"APP-----APPAPPAPP-----BARBARAPP-----FOOFOOAPP-----Foo BarFoo BarAPP-----========== SYSSTATEMENTS ==========<systemid><systemname>APPT<validityflag>insert into removed select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLD where x not in (select x from new org.apache.derby.catalog.TriggerNewTransitionRows() NEW where x < 10)<systemid>APPnull-----<systemid><systemname>APPT<validityflag>select c from bar."tWithKeys"<systemid>APPnull-----<systemid><systemname>APPT<validityflag>update bar.t4 set j=8 where i=2<systemid>APPnull-----<systemid><systemname>"Quoted"Schema"T<validityflag>values(8)<systemid>APPnull-----<systemid><systemname>BART<validityflag>select * from new org.apache.derby.catalog.TriggerOldTransitionRows() OLDTABLE <systemid>APPnull-----<systemid><systemname>Foo BarT<validityflag>values (1), (2)<systemid>APPnull-----========== SYSTABLES =========="tquoteTwo"tquoteTwoTAPPR-----MULTI WORD NAMEMULTI WORD NAMETBARR-----REMOVEDREMOVEDTAPPR-----SYNONYM1SYNONYM1AAPPR-----SYNONYM2SYNONYM2ABARR-----SYNONYM3SYNONYM3ABARR-----T10T10TFOOR-----T11T11TAPPR-----T1T1TAPPR-----T1T1TBARR-----T2T2TAPPR-----T3T3TBARR-----T3_2T3_2TBARR-----T4T4TBARR-----T4_2T4_2TBARR-----T5T5TFoo BarR-----T6T6TFoo BarR-----T7T7TFoo BarR-----T8T1T4T8T1T4TAPPR-----T8T8TBARR-----T9T9TFOOR-----V"3V"3VAPPR-----V1V1VAPPR-----V1V1VFOOR-----V2V2VAPPR-----XXTAPPR-----tWithKeystWithKeysTBARR-----tee""Heetee""HeeT"Quoted"Schema"R-----tquote"Onetquote"OneTAPPR-----tquoteThree"tquoteThree"TAPPR-----viewTwoviewTwoVBARR-----========== SYSTRIGGERS ==========<systemid>"trig"One""Quoted"Schema"<systemid>IAREtee""Heenull<systemid>nullvalues(8)falsefalsenullnull-----<systemid>REFTRIGBAR<systemid>DASET8null<systemid>nullselect * from oldtabletruefalseOLDTABLEnull-----<systemid>TRIG2Foo Bar<systemid>DBSET1null<systemid>nullvalues (1), (2)falsefalsenullnull-----<systemid>TRIGFOURAPP<systemid>UASEXnull<systemid>(1)insert into removed select * from old where x not in (select x from new where x < 10)truetrueOLDNEW-----<systemid>TRIGONEAPP<systemid>IARET3null<systemid>nullupdate bar.t4 set j=8 where i=2falsefalsenullnull-----<systemid>TrigThreeAPP<systemid>UAREtWithKeysnull<systemid>(1,2)select c from bar."tWithKeys"falsefalsenullnull-----========== SYSVIEWS ==========V"3create view "V""3"(i) as values (8), (28), (78)NAPP-----V1create view v1 (dum, dee, dokie) as select a.d, a.c, b.p1 from t1 as a, bar.t3 as bNAPP-----V1create view v1 (doo, dwa) as select num, letter from "Foo Bar".t6NFOO-----V2create view v2 as select * from bar.t1NAPP-----viewTwocreate view bar."viewTwo" as select * from app.t11NAPP-----Database 'wombat_new' deleted.[ Done. ]⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -