can we list all tables in msaccess database using sql?

by

Use MSysObjects

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

More Related Contents:

  1. Address standardization within a database
  2. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  3. How can I implement SQL INTERSECT and MINUS operations in MS Access
  4. Lightweight SQL database which doesn’t require installation [closed]
  5. SQL: Using NULL values vs. default values
  6. How does database indexing work? [closed]
  7. Insert into … values ( SELECT … FROM … )
  8. Refactor a PL/pgSQL function to return the output of various SELECT queries
  9. IN vs OR in the SQL WHERE Clause
  10. How do I write a full outer join query in access
  11. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  12. Where is |DataDirectory| defined?
  13. When to use SQL Table Alias
  14. why is null not equal to null false
  15. SQL server query to get the list of columns in a table along with Data types, NOT NULL, and PRIMARY KEY constraints
  16. create table with sequence.nextval in oracle [duplicate]
  17. Does DB2 have an “insert or update” statement?
  18. How do I implement pagination in SQL for MS Access?
  19. Android multiple databases open
  20. What is it exactly a BLOB in a DBMS context
  21. Composite Primary Keys : Good or Bad?
  22. Convert String to Date in MS Access Query
  23. Is there a version control system for database structure changes?
  24. What does ON [PRIMARY] mean?
  25. How do you interpret a query’s explain plan?
  26. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  27. Select query with date condition
  28. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  29. Microsoft Access – Case Query
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment