Re: dumb sql question

Posted in 1993

Dave Snyder — Tue, 9 Mar 1993 23:10:45 -0500 (EST) — source: Informix-list mailing list archive (1991-1998)

Quoting Matthew Mashyna... } } Is there a way to querry a database (whose name you do know) and get a } list of its tables ? I'd also like to get a list of columns for a table } (once I know its name) } How 'bout this... SELECT tabname FROM systables WHERE tabid >= 100; And also this... SELECT colname FROM systables, syscolumns WHERE systables.tabid = syscolumns.tabid AND tabname = "some_table_name"; DAS -- David Snyder @ Snide Computer Services - Folcroft, PA Current Release is db4glgen-3.9 UUCP: ..!uunet!das13!dave INTERNET: dave.snyder@snide.com