List of table names

  • Thread starter Prashantha Weerakoon
  • Start date
P

Prashantha Weerakoon

Hello all

What is the sql query that fetches all the table names that exist in the
access database...


/thanks in advance
PRash
 
N

Nikos Yannacopoulos

SELECT MSysObjects.Name
FROM MSysObjects
WHERE (Name Not Like "MSys*") AND )Type In (1,2,4,6))

HTH,
Nikos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fetch rows given row nos 3
Fetch list of table names in access to a record set 1
Access Print Files from Query Results 0
VBA - retrieve data on last create named range from previous inserted named range 0
getting Tags ID used in queries 3
How to list all tables in a database that are NOT empty? 1
Append Query - destination table not available 6
Question on Pass-through Query 4

Top