View List of Tables

[Pravin Prabhu]

How Can I View the List of Tables in any database using SQL Queries in
Access?

 

[Uwe Ricken]

Hi Pravin,

use the following statement (or create a view)

SELECT Name
FROM dbo.sysObjects
WHERE type = 'U'

HTH ;-)

--
Gruß, Uwe Ricken
MCP for SQL Server 2000 Database Implementation

GNS GmbH, Frankfurt am Main
http://www.gns-online.de
http://www.memberadmin.de
http://www.conferenceadmin.de
____________________________________________________
APP: http://www.AccessProfiPool.de
dbdev: http://www.dbdev.org
FAQ: http://www.donkarl.com/AccessFAQ.htm