https://blog.csdn.net/qq_40205468/article/details/88415849

通过系统视图可以查看到所有模块对象下的单一实体的名称和具体的实现代码

             其中：类型 P---->存储过程

                                FN--->函数

                                V--->视图

                                TR-->触发器

SELECT  sm.object_id AS 实体对象ID ,

        OBJECT_NAME(sm.object_id) AS 对象名称 ,

        o.type AS 对象类型 ,

        o.type_desc AS 类型描述 ,

        sm.definition AS 具体代码

FROM    sys.sql_modules AS sm

JOIN sys.objects AS o ON sm.object_id = o.object_id

ORDER BY o.type;