USP_SMARTQUERYINSTANCE_DELETESTATICTABLE

        create procedure dbo.USP_SMARTQUERYINSTANCE_DELETESTATICTABLE
            @SMARTQUERYINSTANCEID uniqueidentifier
        with execute as owner
        as
        set nocount on

        declare @TableName as nvarchar(128)
        declare @TableID as integer
        declare @SQL as nvarchar(300)
        set @TableName = dbo.UFN_SMARTQUERYINSTANCE_MAKEIDSETSTATICTABLENAME(@SMARTQUERYINSTANCEID) 

        select @TableID = id from dbo.sysobjects where id = object_id(@TableName) and OBJECTPROPERTY(id, 'IsUserTable') = 1
        if @TableID > 0
            -- drop existing table
            exec ('DROP table [' + @TABLENAME + ']')

        return 0