Re: how do I list tables in a database?

>Subject: Re: how do I list tables in a database?
>From: Brijesh <brijesh_at_enteract.com>

The answer previously given will work IF you have dba rights. However, if you're simply trying to determine which tables belong to YOU (or the user you're logged on as, to be more precise), simply select from either the TAB table or the TABS table. The TAB table is a brief list of each table in your schema. The TABS table is a similar table with more detail. (Actually, both are Views, but that's not really important here). These tables will give you a quick list of your tables.....

GOOD LUCK!!! Received on Mon Jul 21 1997 - 00:00:00 CDT