Check if #Temp Table Exists? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Check if #Temp Table Exists?

Message

De

24/04/2003 14:35:36

Sergey Berezniker
New York, États-Unis

À

24/04/2003 14:33:44

Alvin Lourdes
Children and Youth Services Cluster
Toronto, Ontario, Canada

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: Check if #Temp Table Exists?

Divers

Thread ID:

00781242

Message ID:

00781244

Vues:

13

This message has been marked as the solution to the initial question of the thread.

>Hi,
>
>I want to delete a temp table if it exists only..
>
>
>I have tried IF EXISTS... it didnt work.
>
>Any ideas?
>
>Alvin

IF object_id('tempdb..#ProgList') IS NOT NULL
	DROP TABLE #ProgList

--sb--

Click here to load this message in the networking platform