Hi,<br>
<br>
I'm looking to run an SQL to find the tables in a particular DB. I know SQL but am unfarmiliar with Informix.<br>
<br>
Any help appreciated.<br>
<br>
C
Hi,<br>
<br>
A better solution is<br>
select tabname from systables where tabid < 100;<br>
<br>
Tabid 1 - 100 are reserved for Informix's own use.<br>
<br>
HTH,<br>
Ravi...
oops, that should be<br>
select tabname from systables where tabid > 99;<br>
<br>
Tabid 1 - 99 are reserved for Informix's own use.<br>
<br>
HTH,<br>
Ravi...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.