Re: drop whatever temp;

From: Mark Styles <news_at_lambic.co.uk>
Date: Wed, 07 Nov 2001 18:01:37 GMT
Message-ID: <jjtiut4n94ifh99gmksebv76gsr00qkkdf@4ax.com>

On Wed, 07 Nov 2001 18:45:43 +0100, Andreas Koch <mail_at_kochandreas.com> wrote:

>In a script i create a table temp.
>To prevent it failing if some other script created
>a temp and didn't delete it, i use
>drop table temp;
>drop view temp;
>drop trigger temp;
>....
>before the statement.

Seems a bit dangerous, what if another script is running and using it's temp when you try to create yours? Better to create a unique temporary table name. Received on Wed Nov 07 2001 - 12:01:37 CST