[teiid-issues] [JBoss JIRA] (TEIID-4565) Add objects table to system schema

[Tom Johnston (JIRA)]

Tom Johnston created TEIID-4565:
-----------------------------------

             Summary: Add objects table to system schema
                 Key: TEIID-4565
                 URL: https://issues.jboss.org/browse/TEIID-4565
             Project: Teiid
          Issue Type: Feature Request
            Reporter: Tom Johnston
            Assignee: Steven Hawkins


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 ('SYS','pg_catalog','SYSADMIN')
UNION
select c.tableName as Parent,c.name, c.uid,'Column' as ObjectType
from sys.columns c
where schemaName not in ('SYS','pg_catalog','SYSADMIN')
UNION
select null as Parent,e.Value as Name,e.uid,'Property' as ObjectType
from sys.properties as e) as SysObjects





--
This message was sent by Atlassian JIRA
(v7.2.3#72005)