Welcome toVigges Developer Community-Open, Learning,Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
2.0k views
in Technique[技术] by (71.8m points)

can we list all tables in msaccess database using sql?

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' 
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Use MSysObjects

SELECT * FROM MSysObjects WHERE Type=1 AND Flags=0

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to Vigges Developer Community for programmer and developer-Open, Learning and Share
...