Re: 'sys'

In article <1nlkotINNmp5@emory.mathcs.emory.edu> jparker@hpbs2561.boi.hp.com (Jack Parker) writes: >Hi Alan, >> -> >> ->> WHERE NOT tabname MATCHES "sys*" { to not print the system catalog tables } >> -> ^^^^^^^^^^^^^^^^^^^^^^^^ >> -> >> ->I like that, although personally I use where tabid > 99 since all systables >> ->(except sysmenus and sysmenuitems) have tabid's under 100 - until of course >> ->you manually change them. >> >> Hi, Jack, >> >> Don't forget about syscolval and syscolatt, which are created by upscol. >> I also have syscoldef, systabdef, and syssubdb, which are used in my own >> special data dictionary. >> > >Maybe the thing to do is create a view of systables and 'some_other_table' >which has a single field/flag denoting whether it should be displayed in >the schema you wish to print. Perhaps even a smallint so you can do schemas >of 'group 1' or whatever - since databases frequently have a cross of tables >- some for permissions, others for configuration info etc., etc. > >j. >_____________________________________________________________________________ >Jack Parker - Contractor | >Hewlett Packard, BSMC Boise, Idaho, USA| I've forgotten more than >jparker@hpbs2561.boi.hp.com | I ever knew >(208) 323-5388 (W) (208) 384-1623 (H) | >_____________________________________________________________________________ I am writing a paper on UniSQL. Any information on UniSQL and it's comparision with other extended databases will be of great help to me and will be greatly appreciated. Thank you.