P Pravin Prabhu Jun 15, 2004 #1 How Can I View the List of Tables in any database using SQL Queries in Access?
U Uwe Ricken Jun 15, 2004 #2 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
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