2

I tried many queries like using this 

SELECT TABNAME,COLNAME from SYSCAT.COLUMNS where TABNAME='DETAILS'

Also used user_tabs in place of SYSCAT.COLUMNS as well, but it does not work in informix.

Jesse
  • 8,605
  • 7
  • 47
  • 57
razor
  • 173
  • 2
  • 14
  • 2
    Not sure I understand, are you asking about finding schema information? Table names and column names? [This old post might help](http://stackoverflow.com/questions/1380782/informix-sql-list-all-fields-tables) – mconlin May 06 '13 at 02:06
  • what is your expected result? – Gnanz May 10 '13 at 07:05

1 Answers1

2

Informix does not install the Information Schema tables necessary to support your query; indeed it does not use the schema name ('owner' in Informix parlance) of SYSCAT when it does have (the very old version of) the Information Schema installed.

There's a file $INFORMIXDIR/etc/xpg4_is.sql that you can run for a given database that will install tables informix.TABLES and informix.COLUMNS but not a table user_tabs.

Jonathan Leffler
  • 730,956
  • 141
  • 904
  • 1,278