Dropping a table in a database syntax

[ccampbell]

How can I check to see if a database table exists, and then if it does exist, drop it.
(ie
IF(TABLE TESTER EXISTS)
DROP TABLE TESTER
I am having a problem with the correct syntax. Could someone please help me with that.

 

[tlbroadbent]

Here is one way to accomplish that.

if exists
(select * from dbo.sysobjects
where id = object_id(N'[dbo].[tablename]')
and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tablename]
GO
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[ccampbell]

THANKS TERRY,
ONCE AGAIN YOU COME TO THE RESCUE. THAT WORKED BEAUTIFULLY