Thread: 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:
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.