Hi,
I've found these to be helpful

select * from syscat.tables
select * from syscat.columns
select * from syscat.enumtypes
Select colname from syscat.columns where tabname='OCCUPANCY' and
tabschema='TSMDB1'


On Fri, Jun 2, 2017 at 8:05 AM, Jeannie Bruno <JBruno AT cenhud DOT com> wrote:

> Hello.   Ya know how in TSM one can write queries against a  Table on the
> TSM database (ie: select sum from SUMMARY or select * from NODESVIEW).
>
> Does anyone know the command or query that tells me all the Table names on
> the database?  I can't find....
>
>
> ____________________
> Jeannie Bruno
> Senior Systems Analyst
> jbruno AT cenhud DOT com<mailto:jbruno AT cenhud DOT com>
> Central Hudson Gas & Electric
> (845) 486-5780
>



--

PGP PUBLIC KEY

https://keybase.io/marouf/key.asc