学步园

--查询所有表
SELECT * FROM sys.objects WHERE  type in (N'U')
--查询某一个表
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[EVADELSECURITYPROJECT]') AND type in (N'U')

--查询所有函数
SELECT * FROM sys.objects WHERE   type in (N'FN')
--查询一个函数
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[checkifneedretir]') AND type in (N'FN')

--查询所有存储过程
SELECT * FROM sys.objects WHERE   type in (N'P')
--查询一个存储过程
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[can_工作日志]') AND type in (N'P')

--查询所有视图
SELECT * FROM sys.objects WHERE   type in (N'V')
--查询一个视图
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[can_resptarget]') AND type in (N'V')