USE [database]
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[table]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[table]

USE [Tempdb]
GO

CREATE SCHEMA foo
GO

CREATE TABLE foo.bar ([woo] BIT)
INSERT foo.bar VALUES (1)
GO

IF OBJECT_ID('foo.bar') IS NOT NULL
	SELECT 'Foo.Bar Exists'
ELSE
	SELECT 'Foo.Bar DOES NOT Exist'
GO

DECLARE @schemaName SYSNAME = 'foo'
DECLARE @tableName SYSNAME = 'bar'

DECLARE @QualifiedName SYSNAME = QUOTENAME(@schemaName) + '.' + QUOTENAME(@tableName)
DECLARE @sql NVARCHAR(MAX)

IF OBJECT_ID(@QualifiedName) IS NOT NULL
BEGIN
	SET @sql = 'DROP TABLE ' + @QualifiedName
	PRINT @sql
	EXEC sp_executeSql @sql
END


IF OBJECT_ID('foo.bar') IS NOT NULL
	SELECT 'Foo.Bar Exists'
ELSE
	SELECT 'Foo.Bar DOES NOT Exist'
GO

-- Cleanup
DROP SCHEMA foo
GO