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

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4565?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13319055#comment-13319055 ] 

Steven Hawkins commented on TEIID-4565:
---------------------------------------

Note that properties are not objects by themselves, so e.uid refers to the object who has that property.  Also do you mean for the view to contain all object types (not just table/column)?  Can you provide a full example of how you would use this?

> 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 (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



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