0

Field for Table Names in "IncortaMetadata" schema?

I am trying to pull all the schema and table names from IncortaMetadata for some analysis. I was able to find the schema name (IncortaMetadata.SCHEMA.Name) but I can't find Table names (Files/MaterializedViews/Aliases etc.) in any field. Does IncortaMetadata not store that? If so, is there another way to extra a list of all the "Tables" in each schema? Any help would be great.

 

Thanks,

Amar

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Amar Meena -- some of the metadata stored in the IncortaMetadata database is stored in XML.  For table definitions (and dashboard definitions) you will have to pull out and parse the XML to get to the lower level details.

    Like
  • Please install the Inspector tool and it will give all those and more details .

    Like 1
Like Follow
  • 1 mth agoLast active
  • 2Replies
  • 21Views
  • 3 Following