So far, I found there are some interesting ways to search in global structure:
InterSystems FAQ rubric
Too run SQL in Terminal use $system.SQL.Shell().
Please refer to the sample below.
InterSystems Caché is a multi-model DBMS and application server. See more details here.