DBC Tables

Database
Enthusiast

DBC Tables

Hi

I ran query :
Help Database DBC; and it gave me 'X' number of rows output resultset.But i cant figure out a table ErrorMsgs which is present in DBC in those 'X' rows output.

But if i query Select * from DBC.ErrorMsgs, it works fine.

Why is it that this table "ErrorMsgs" misses out from resultset of query Help Database DBC;

Thanks

2 REPLIES
Junior Contributor

Re: DBC Tables

HELP USER DBC simply doesn't return any table info unless user dbc submits that statement.

Don't ask me why, it's probably because end users are not supposed to query any system table directly, but through system views.

Dieter
Enthusiast

Re: DBC Tables

Thanks Deiter.