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'
Advertisement
Answer
Use MSysObjects
SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0
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