Re: Drop if exists
In article <7squ30$g31$1@nnrp1.deja.com>, joel_anderson@prosolution.com
writes
>I have a very large script used to modify customer databases. The
>script drops tables, creates tables, and alters tables. The script
>also creates and executes dozens of stored procedures. This script
>runs from dbaccess.
>
>Is there a way in an SQL script to detect if a table, stored procedure,
>index etc. exists before dropping it?
>
No, if you do
dbaccess <database> < <script>
then errors are ignored..
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
--
David Williams