show tables in informix?

amachou_doubaji · #1 (**permalink**) 03-31-04, 04:12

hi ,all
please there is any difference between sql for mysql and sql informix
if yes give me the equivalent command of " show tables "
i'll be tankfull ,please it's urgent.

lloydnwo · #2 (**permalink**) 03-31-04, 06:53

Quote:

Originally posted by amachou_doubaji
hi ,all
please there is any difference between sql for mysql and sql informix
if yes give me the equivalent command of " show tables "
i'll be tankfull ,please it's urgent.

Hi,

To view your tables you can run "dbaccess" or "isql" utility of informix and from command prompt give the command
dbschema -d <database name> -t <table name>

shkumesh · #3 (**permalink**) 04-08-11, 07:40

Give try :

info tables

InformixWilli · #4 (**permalink**) 04-09-11, 18:51

Code:

select * from systables;

Internet Services

Web Development

Digital Marketing

Consumer Tech