Db2 list tables for all


-----Original Message-----
From: Saminathan
[mailto:db2udbdba-ezmlmshield-x91755740.[Email address protected]
Sent: Thursday, July 29, 2004 1:23 PM
To: LazyDBA Discussion
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