How to list all table names in ms access

Cara pertama:

SELECT MSysObjects.Name FROM MSysObjects WHERE (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1)) ORDER BY MSysObjects.Name

Cara kedua:

SELECT Name
FROM MSysObjects
WHERE
Left([Name],1)<>”~”
AND
Left([Name],4)<>”MSys”
AND
Type In (1,4,6)
ORDER BY Name;

Advertisement