SQL Query: get table names

[Aqueel]

Hi How can i names of all the tables from a Microsoft Access Database? Is there any query to do it?

We Believe in Excellence www.aqueelmirza.cjb.net

[_AK_]

you can get it like this: SELECT name FROM dbo.sysobjects WHERE xtype = 'U'

Best Regards, Apurva Kaushal

[Eric Dahlvang]

SELECT name FROM MSysObjects where type = 1

--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters