SELECT NAME FROM SYSIBM.SYSTABLES WHERE TYPE = 'T' AND CREATOR IN ('S1','S2','S3') ORDER BY NAME;

Raul Delhumeau

-----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