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
2.1m questions
2.1m answers
60 comments
57.0k users