Menu
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'
369
Click on the View tab and check System objects. If you are using Microsoft Access 2007, 2010, 2013, or 2016, right-click on the navigation pane (just above the search box) and choose Navigation Options. Then, under display options, check Show System Objects and press OK.
Query: SELECT table_name FROM user_tables; This query returns the following list of tables that contain all the tables owned by the user in the entire database.
Use MSysObjects
SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
