Question Yuri Marx · Jun 27, 2020 Example list persistent classes with name, type, primary key and foreign keys using %Dictionary #ObjectScript #InterSystems IRIS Hi guys, Do you have any objectscript sample to list persistent classes with name, type, primary key and foreign keys using %Dictionary? 1 2 645
Eduard Lebedyuk · Jun 28, 2020 Persistent classes: SELECT Name FROM %Dictionary.ClassDefinition_SubclassOf('%Persistent') List properties and relationships (if you need subset - filter by parent - it's a class): SELECT parent, Name, Cardinality, Collection, Id, _Identity, Relationship, Type FROM %Dictionary.CompiledProperty Foreign keys: SELECT parent, Name, Properties, ReferencedClass, ReferencedKey FROM %Dictionary.ForeignKeyDefinition For everything %Dictionary.Compiled* - includes defined and inherited values, Definitions include only items defined in a current class.
Persistent classes:
List properties and relationships (if you need subset - filter by parent - it's a class):
Foreign keys:
For everything %Dictionary.Compiled* - includes defined and inherited values, Definitions include only items defined in a current class.