Does Jet SQL support queries on Information Schema?

M

Michel Walsh

Hi,


I am not aware of a adSchemaInformation. Sure, Jet supports some Schema,
and some not.


? CurrentProject.Connection.OpenSchema(adSchemaTables).GetString



would list the "tables" ( Access tables, System tables, Views, Links and
tables )


Hoping it may help,
Vanderghast, Access MVP
 
L

Laser Lu

Dear All,

Does the Microsoft Jet SQL support queries on Information Schema? If true,
then what's the syntax of the query statement?

Thanks!
Laser Lu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Differentiate between "system" and "user" SQL views 1
exporting into a SQL Server schema 3
Modifying Table through Access in different Schema on SQL 2005 0
BCM Database schema information 1
query links to SQL server and mdb table 1
schema to text file 7
maximum number of indexes per SQL table that Access (jet) can dealwith? 0
Generating diagrams from SQL schema 1

Top