How to list tables in an SQL database

[Jan Schenkel]

--- Mark Wieder <mwieder at ahsoftware.net> wrote:
> Jan-
> 
> Tuesday, January 27, 2004, 2:01:48 AM, you wrote:
> 
> The only way I know of to get a list of tables from
> MSAccess with a
> direct SQL statement is:
> 
> SELECT * from MSysObjects where type=6;
> 
> -- 
> -Mark Wieder
> 

Thanks Mark -- if anyone else knows similar SQL
statements for other databases than MySQL, Oracle,
Valentina and now Access : don't hesitate to post them
to the list or email them to me directly :-)

Jan Schenkel.

=====
"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/