List all the schemas, tables and columns in Cache database
Hi Cache team, I am in the need of listing all the user defined schemas that are present my Cache db and also the user defined tables and views and Columns of those tables and views through Queries. So that I can write some JDBC code to run the queries and fetch the above metadata. Any help is appreciated.
Thanks in Advance,
Kranthi kiran.
Look at the %Dictionary tables, you can find the docs here :
https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic....
Also look at following answer for examples :
https://community.intersystems.com/post/example-list-persistent-classes-...
Speaking about "Relational World" is better to use Classes/Tables of package
INFORMATION.SCHEMA
In this post has a little example: https://community.intersystems.com/post/describe-table-cache-db?page=1#comment-128856
Regards.