you can query syscat.tables and syscat.indexes to verify whether a
table/view/index exists or not.....

-----Original Message-----
From: Justin James
[mailto:db2udbdba-ezmlmshield-x6760920.[Email address protected]
Sent: Wednesday, October 27, 2004 9:54 AM
To: LazyDBA Discussion
Subject: [db2/i-series] drop tables/view/index If exists


How do I detect if an index / view / table already exists in order that I
can drop it and then recreate it without generating any errors?


___________________________________________________________
HPD Software Ltd. - Helping Business Finance Business
Email terms and conditions: www.hpdsoftware.com/disclaimer




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


-------------------------------------------------------------------------------------------
***National City made the following annotations
-------------------------------------------------------------------------------------------
This communication is a confidential and proprietary business communication. It is intended solely for the use of the designated recipient(s). If this communication is received in error, please contact the sender and delete this communication.
===========================================================================================

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