Re: TAbles/Columns missing in information schema

2019-05-10 Thread David G. Johnston
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.

Re: TAbles/Columns missing in information schema

2019-05-10 Thread Susan Hurst
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

TAbles/Columns missing in information schema

2019-05-10 Thread Susan Hurst
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