> While I like your idea. I can't say I agree with the > implemenation. I > have some users that use the > F3 to develop some basic queries and I wouldn't want > them to ever have > access to the SYS > tables. I would like to see this myself as a > developer, but I think it > ought to be just a command > like SET F3SYS YES or SET F3SYS NO, this way it > could be implemented > for the ones I want > and not for the ones I don't with the DEFAULT being > NO.
I was thinking about this last week when I was writing some DB meta code. I prefer Jim's solution, since it is less likely to be misused. Furthermore, a SET SYSTABLES ON/OFF switch could also apply to general LIST statements as well -- we could choose if SYS_ tables showed up in LIST. An alternative is to leave it like it is and force us developers to declare shadow tables on the system tables when we want to use them. -- Larry
