DECLARE @lccSSchemaName varchar(100);
DECLARE @lccSTableName varchar(100);
DECLARE @lccSShemaTable varchar(100);
DECLARE @lccSCommand varchar(200);
SET @lccSSchemaName='[~lccParamSchemaTarget~]';
SET @lccSTableName='[~lccParamTableTarget~]';
SET @lccSShemaTable=@lccSSchemaName+'.'+@lccSTableName;
IF EXISTS
(SELECT TOP 1 T2.name As SchemaName,T1.name As TableName
FROM sys.tables T1
inner join sys.schemas T2 on T1.schema_id = T2.schema_id
WHERE T2.name=@lccSSchemaName AND T1.name=@lccSTableName)
BEGIN
SET @lccSCommand = 'DROP TABLE '+@lccSShemaTable+';';
EXEC(@lccSCommand);
SELECT 'Dropped:'+@lccSSchemaName+'.'+@lccSTableName;
END