mssql的object_id

--检查当前数据库的对象类型select distinct type,type_desc from sys.objects order by typetypetype_descD DEFAULT_CONSTRAINTF FOREIGN_KEY_CONSTRAINTFNSQL_SCALAR_FUNCTIONITINTERNAL_TABLEP SQL_STORED_PROCEDUREPKPRIMARY_KEY_CONSTRAINTS SYSTEM_TABLESQSERVICE_QUEUETFSQL_TABLE_VALUED_FUNCTIONTRSQL_TRIGGERU USER_TABLEV VIEW-- 如果删除某个表对象可以使用if (object_id('ta','U')) is not nulldrop table ta