See Whether A Table Exists Or Not

[arpan]

How do I find out whether a table exists or not in SQL Server? What I want to do is if the table exists, then DROP it while a stored procedure is being executed.

Thanks,

Arpan

 

[lemosley01]

Check for the table using IF EXISTS as in:

if exists 
(select TABLE_NAME from INFORMATION_SCHEMA.TABLES 
where TABLE_NAME='Categories' and 
TABLE_SCHEMA='dbo'
)
[DROP STATEMENTS HERE]

ELSE
[do other stuff]