Get list of Tables and Views from Intersystems.Cache
Posted on 2014-03-28
We have some 3rd party software that uses an older version of Intersystems Cache to store it's data. We have access to query it through the Intersystems.Data.CacheClient.dll (custom ODBC driver that comes with it)
I can query a database table fine, but I am trying to get a listing of the tables and/or views that exist in a database and I can't figure out how to do that. I am working in VB.NET.
I also notices there is a Intersystems.Data.CacheTypes class that might be helpful, but I am not sure.
Lastly, the Views don't seem to be query-able directly. Is that normal or am I doing something wrong?
Any help with any of the above would be welcome. Thanks in advance...