TAbles/Columns missing in information schema
Why would schemas/tables/columns be missing from
information_schema.tables/information_schema.columns?
We recently promoted some new tables to production but only 2 of the 4
schemas appeared in
information_schema.tables/information_schema.columns.
The schemas/tables/columns do exist as expected but they are not
represented in information_schema.tables/information_schema.columns.
Why is that? Where can I find the missing info for use in a view that
displays the tables and columns in a database?
Thanks for your help!
Sue
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hurst@brookhurstdata.com
Mobile: 314-486-3261
On Fri, May 10, 2019 at 3:46 PM Susan Hurst <susan.hurst@brookhurstdata.com>
wrote:
Why would schemas/tables/columns be missing from
information_schema.tables/information_schema.columns?
The user you are using to check information_schema doesn't have permissions
on the objects in question?
David J.
Oh my!
I'll check on that...thanks, David!
---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hurst@brookhurstdata.com
Mobile: 314-486-3261
On 2019-05-10 17:51, David G. Johnston wrote:
Show quoted text
On Fri, May 10, 2019 at 3:46 PM Susan Hurst <susan.hurst@brookhurstdata.com> wrote:
Why would schemas/tables/columns be missing from
information_schema.tables/information_schema.columns?The user you are using to check information_schema doesn't have permissions on the objects in question?
David J.