'sys'

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) | _____________________________________________________________________________