Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4565

Add objects table to system schema

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Unresolved
    • Major
    • Backlog
    • None
    • Query Engine
    • 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            tljohnst@gmail.com thomas johnston (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: