SQL Server 判定表是否存在

-----判定实体表是否存在
IF EXISTS ( SELECT  *
            FROM    sys.objects
            WHERE   NAME = 'test' )
    BEGIN
        DROP TABLE test
    END
   
-----判定临时表是否存在
IF OBJECT_ID('tempdb..#temp_test') IS NOT NULL
    DROP TABLE #temp_test

-----判定表是否存在某一字段
IF NOT EXISTS ( SELECT  *
                FROM    sys.columns c
                        LEFT JOIN sys.objects o ON o.[object_id] = c.[object_id]
                WHERE   o.NAME = 'account_category_article_rel'
                        AND c.NAME = 'max_redemption_qty')
    BEGIN 
   
ALTER TABLE dbo.account_category_article_rel ADD max_redemption_qty INT NULL

END