This discussion post is outdated and has been archived. Please use the Community question forums and official documentation for the most current and accurate information.
[ARCHIVED] INFORMATION_SCHEMA - CONSTRAINTS AND INDEXES
It would great if we could programmatically view the keys, constraints (including foreign keys) and indexes, but most of the tables in the information_schema that should contain that information are not returning any rows.
Could that be changed? Am I missing something? I know that in Oracle, you cannot see anything that you do not have permission to see.
Thank you for bringing this up. We should do this. I created a story to track the work. We will try to get it into V1. If you would like to follow up reference story DS-145.
Thank you for bringing this up. We should do this. I created a story to track the work. We will try to get it into V1. If you would like to follow up reference story DS-145.
This discussion post is outdated and has been archived. Please use the Community question forums and official documentation for the most current and accurate information.