How to saw all tables through query

  • Thread starter Thread starter dilip
  • Start date Start date
D

dilip

I want to saw all tabled through sql query in msaccess
2000 , like in ORACLE we write "Select * from tab". same
as what should we write for view all tables
 
Try:

SELECT MsysObjects.Name FROM MsysObjects
WHERE (([Type] = 1) AND ([Name] Not Like "~*") AND ([Name] Not Like
"MSys*"))
ORDER BY MsysObjects.Name;

Include type 6 if you want to show linked tables, and type 4 for ODBC linked
tables.
 
Back
Top