Re: dumb sql question

Quoting Alan Popiel... } } Anyway, try these: } } SELECT tabname FROM systables } WHERE NOT tabname MATCHES "sys*" { to not print the system catalog tables } } ORDER BY tabname } ; } SELECT tabname table_name, colname column_name, colno column_order } FROM systables t, syscolumns c } WHERE t.tabid = c.tabid } AND NOT tabname MATCHES "sys*" { to not print the system catalog tables } } ORDER BY tabname, colno } ; } Well you just ommitted 3 user tables from my database because they just happen to begin with "sys". It's much safer to say: WHERE tabid >= 100 DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.9 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com