yellow,



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


The situation is like this....

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!