On Fri, May 10, 2019 at 3:46 PM Susan Hurst
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.hu...@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 Sus
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 expec