Sami,

db2 > List tables for schema s1
db2> list tables for schema s2
db2> list tables for schema s3

or to list for all schemas

db2> list tables for all

or

db2 > Select TABSCHEMA, TABNAME, DEFINER from SYSCAT.TABLES where tabschema
IN ('S1','S2','S3')
tabschema is the schema name & Definer is the user name


Regards
thirumaran

----- Original Message -----
From: "Saminathan" <db2udbdba-ezmlmshield-x91755740.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, July 29, 2004 10:53 PM
Subject: How to list tables in another schema


>
> Hi All,
>
> I have username U1 & Schema name S1,S2 and S3.
>
> I did login as U1. How do I see all the tables listed under S1,S2 and S3
> schemas.
>
>
> Thanks
> Sami
>
>
>
>
>
> ************************************************************************
> This E-mail is confidential. It may also be legally privileged. If you
> are not the addressee you may not copy, forward, disclose or use any
> part of it. If you have received this message in error, please delete
> it and all copies from your system and notify the sender immediately
> by return E-mail.
>
> Internet communications cannot be guaranteed to be timely, secure,
> error or virus-free. The sender does not accept liability for any
> errors or omissions.
> ************************************************************************
>
>
> ---------------------------------------------------------------------
> PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
> website: http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: db2udbdba-[Email address protected]
>


DB2 & UDB email list listserv db2-l LazyDBA home page