Details
-
Feature Request
-
Resolution: Unresolved
-
Major
-
None
-
None
Description
The addition of a objects table would make it simpler to join to when extensions are implemented.
An example might be something similar to this query:
select sysObjects.*
from (
select t.schemaName as Parent,t.name, t.uid ,'Table' as ObjectType
from sys.tables t
where schemaName not in (select distinct(schemaName) from "SYS"."Tables" where isSystem = true)
UNION
select c.tableName as Parent,c.name, c.uid,'Column' as ObjectType
from sys.columns c
where schemaName not in (select distinct(schemaName) from "SYS"."Tables" where isSystem = true)
UNION
select null as Parent,e.Value as Name,e.uid,'Property' as ObjectType
from sys.properties as e) as SysObjects