Re: Test for the exsistance of a table

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 08 Mar 2002 19:01:36 +0100
Message-ID: <q2vh8u8coe1o6ha14s1htbpg364r8r2mjb@4ax.com>

On Fri, 08 Mar 2002 15:57:51 GMT, "Philip Morrow" <cracker_at_mymorrow.com> wrote:

>Is there a way to test for the exsistance of a table with SQL code. I need
>to test to see if a table exsists and if so drop it. If it doesn't the drop
>table statement doesn't need to be executed.
>
>Thanks for the help.
>
>Phil
>

Exception handling has been invented to avoid cluttering up all your code with this kind of test.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Mar 08 2002 - 12:01:36 CST