How to Check if SQL Table exists...

yellow,



Anybody knows how to check if a table in SQL exists?


The situation is like this....

Quote:

---

I have a Transact SQL Code which looks like this:

Select * into TempWDetails from [Withdrawal Details]where WithdrawalNumber = @WithdrawalNo

following other SQL Statements

Dropping the Temporary Table
DROP TABLE TempWDetails

---

I want to check if TEMPWDetails exists before I create it....
How can I do this?
Please help me!
I'm desperate............

Is there any system storeprocedure or system functions that checks if table exists.... I really don't know about this...


Thanks!

yellow,


Amidst the desperation... I have accidentally found the solution to my problem.... And I want to share this to you guys...

Code:

---


if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TempWDetails]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
GatherData:
Select * into TempWDetails from [Withdrawal Details] where WithdrawalNumber = @WithdrawalNo

-------other sql transact statments---------------------

DROP TempWDetails
End
else
begin
        DROP TempWDetails
        GOTO GatherData:
end

---

Quote:

---

OBJECT_ID - Returns the database object identification number.
OBJECTPROPERTY - Returns information about objects in the current database.

Syntax
OBJECT_ID ( 'object' )
OBJECTPROPERTY ( id , property )

OBJECTPROPERTY; property named IsUserTable- User-defined table.

---

Thanks guys!
Have a nice day! :wave: :wave: :wave:

In case others don't know how you got that - right-click the table
in question in EM. Click All Tasks > Generate SQL Script >
Formatting tab > check the "Generate the DROP <Object>
command for each object". Then back to the General tab and click
the Preview button. It will generate the drop script for the table.
Copy and paste into text file for use later.

:D