SQL判断对象不存在

对象判断SQL(不存在)
表
IF OBJECT_ID('DBO.TABLENAME','U') IS NULL
列
IF COL_LENGTH('DBO.TABLENAME','COLUMNAME') IS NULL
主键
IF OBJECT_ID('PK_CL_T_EQ_DEPRECIATION','PK') IS NULL
外键
IF OBJECT_ID('FK_T_EQ_DEPRECIATION_UserId','F') IS NULL
标量函数
IF OBJECT_ID('DBO.FN_FNNAME','FN') IS NULL
存储过程
IF OBJECT_ID('DBO.SP_SPNAME','SP') IS NULL
索引
IF NOT EXISTS(SELECT 1 FROM SYS.INDEXES WHERE NAME = 'INDEXNAME')