Can we find all tables in the msaccess using sql .
as we do in sqlserver
select * from sys.tables
in sqlite
SELECT * FROM sqlite_master where type='table'
Use MSysObjects
SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0
1.4m articles
1.4m replys
5 comments
57.0k users