If statistics are maintained regularly for the DB, a quick query of the systables table could tell you if the table exists or not. If you don't find the table, skip the drop query.
It would still be a good idea to use a try/catch block on your drop query though, as you are not gauranteed that systables will be up to date. > hmmm.. if you don't have access then how can you maintain the tables > without the rights to alter them? > > > > >>> [EMAIL PROTECTED] 11/16/2004 8:54:11 AM >>> > >just thinking out loud here... wouldn't the preferred way to do is is > by > >using Oracle's tools instead? > > Well of course. I can do this in about a minute inside of Oracle > itself. Trouble is I don't have access to them so I have to build my > own. The fault of the server admins and not something I can help, > unfortunately. > > -- > --Matt Robertson-- > President, Janitor > MSB Designs, Inc. > mysecretbase.com > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184406 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54