Re: [SQL] sql script testing ?

From: bob sullivan <bsullivn_at_home.com>
Date: Sat, 11 Mar 2000 02:46:47 GMT
Message-ID: <38C9B342.DA3941C8@home.com>

Alain Kreienbuhl wrote:
> Is there a way to test a SQL (DDL) script without it accually doing
> something. Typically after doing some minor changes, I'd like to check
> that the script still holds together w/o having to run the whole script
> again.

Try commenting out all the other lines of the script other than the ones you want to test. When you're sure the changed portion still works, you can take the comment markers out.

cheers,
bob Received on Fri Mar 10 2000 - 20:46:47 CST