how to obtain a list of schemas in intersystems cache?

Question

I'm connecting to a Caché database using the ODBC driver, and I want to do a query to obtain a list of schemas. In Microsoft SQL Server I can use a query like this:

SELECT * FROM INFORMATION_SCHEMA.SCHEMATA

How can I do this in Caché? I'm also using ADO.NET schema collections, but the schemas don't seem to be available there.

score 4 · Accepted Answer · answered Oct 11 '12 at 00:02

4

The schema %dictionary has the tables you are looking for. You could select from %dictionary.compiledclass

answered Oct 11 '12 at 00:02

Stephen Canzano

296
1
3

1

That has a SqlSchemaName column you could group on. – psr Oct 11 '12 at 17:20
This seems to work: SELECT DISTINCT SqlSchemaName from %dictionary.compiledclass – Rn222 Oct 11 '12 at 19:52

how to obtain a list of schemas in intersystems cache?

1 Answers1

Linked