List of table names

  • Thread starter Thread starter Prashantha Weerakoon
  • Start date 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
 
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (Name Not Like "MSys*") AND )Type In (1,2,4,6))

HTH,
Nikos
 
Back
Top