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