how can i get all tables names from MS Access Database

  • Thread starter Thread starter omer kamal
  • Start date Start date
O

omer kamal

Dear all,

Is there any way to display all tables names fom .mdb?

like " SELECT allTableNames FROM DataBaseName"

Regards,
Omer Kamal
 
SELECT MSysObjects.Name
FROM MSysObjects
WHERE (((MSysObjects.Name) Not Like "msys*") AND ((MSysObjects.Type) In
(1,4,6)))
ORDER BY MSysObjects.Name;
 
Back
Top