The following SELECT statement displays databases and users that are owned by the Finance database:
SELECT Parent, Child FROM DBC.ChildrenV WHERE Parent = ’Finance’;
Result:
Parent Child -------- ---------- Finance Personnel Finance Jones Finance Accounting