IF EXISTS DROP TABLE

[pvuppa1]

can anyone tell me how to verify if table exists before I issue DROP TABLE JOBS for the following statement

SET SQLENGINE=SQLMSS
SQL SQLMSS SET SERVER CONN1
SET COMMIT = ON
SQL SQLMSS
BEGIN TRANSACTION
DROP TABLE JOBS
COMMIT WORK ;
END

by the way, im getting this error message when I try to drop a table which is no longer existing.

FOC1400) SQLCODE IS 3701 (HEX: 00000E75) XOPEN: 42S02
: Microsoft OLE DB Provider for SQL Server: [42S02] Cannot drop the table
: 'JOBS', because it does not exist in the system catalog.
(FOC1414) EXECUTE IMMEDIATE ERROR.

thanks in advance
Appreciate ur help

-P

 

[FOCMAN]

Try:

BEGIN TRANSACTION
IF EXISTS (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[jobs]')AND
OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE JOBS