Marc's tumblings and mumblings RSS

By now just a test, as I'm not entirely sure where this would fit into my online activities

Archive

May
20th
Fri
permalink

Note to self: Listing all tables and fields on Informix via SQL

SELECT TRIM(t.tabname) || '.' || TRIM(c.colname) AS table_dot_column
  FROM "informix".systables AS t, "informix".syscolumns AS c
 WHERE t.tabid = c.tabid
   AND t.tabtype = 'T'
   AND t.tabid >= 100
 ORDER BY t.tabname, c.colno

Forgot about the source - otherwise I’d link to it, of course. Sorry!