EA - SQL to show hierarchy of packages?

[BCGoitcwoodard]

Hi -  Can someone share a SQL (SQL Server) query to show the hierarchy of packages in a "project"?  A query to run against the Sparx repository.
Thank you,
CCW

[Geert Bellekens]

query t_package, and join on package_ID = parent_ID

Geert

[BCGoitcwoodard]

Thanks.  And does t_object.ParentID for a column get you to the containing table's object_id?

And then the table's t_object.package_id get you to the containing package's package_id?

[Geert Bellekens]

Columns are stored in t_attribute

t_object.ParentID will give you the owning object.
t_object.Package_ID links to the owning package.

Geert

[BCGoitcwoodard]

Thanks!