Re: Simple request
if ur looking just at the user table names and not the system
tables, then it is :
select tabname from systables where tabid > 99 and tabtype = "T";
On Apr 1, 9:02am, Bill Ennis wrote:
} Subject: Re: Simple request
} select tabname from systables
}
} -Bill
} }
} } Hi,
} }
} } First access to a database (informix):-(
} }
} } How can I get the list of tables ?
} }
} } select * from ...
} }
} } Thanks
} }
} } Dave
} }
}
}
} --
} Bill Ennis Voice: 312-474-7516
} SSA Fax: 312-474-7460
} 500 W. Madison email: ennis@ssax.com ennis@accesschicago.net
}-- End of excerpt from Bill Ennis