get tablenames

Hi,

I need a sql-query to get all tablenames of a scheme or user in a database. select * from tables;
in mysql it's "showtables".

It would be nice if You had a URL or a how-to to get tips for such queries like that in my question.

thanks for Your help!

bye,
Matthias Leonhardt Received on Fri Apr 12 2002 - 08:30:48 CDT