Re: dumb sql question

Posted in 1993

ihor.j.kinal — Thu, 11 Mar 1993 20:47:29 GMT — source: Informix-list mailing list archive (1991-1998)

> In the case of Informix, you can make an assumption on tabid. If you > chance [sic] the "NOT tabname MATCHES 'sys*'" to "tabid > 99" then you'll > skip all of the system tables and find any tables that happen to be > named "sys*". > > Luck, > Will > (uunet!la4gen!villy) > Unfortunately, there's an exception to this [isn't there always?], that has occasionally managed to byte us. A user can create sysmenus & and sysmenuitems tables JUST by executing the User-menu selection from isql. [These tables will be empty, but still there]. This is real easy to do by accident. These have a tabid of > 100 - and to me, they're really system tables. The usual disclaimers apply. Ihor Kinal att!trumpet!ijk