How to list tables in an SQL database

[Mark Wieder]

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
 mwieder at ahsoftware.net