获取SQL Server数据库中所有的用户存储过程
程序员文章站
2022-03-16 21:24:24
...
获取SQLServer数据库中所有的用户存储过程。 无 SELECT SCHEMA_NAME(sp.schema_id) AS [Schema],sp.name AS [Name] FROM sys.all_objects AS spWHERE(sp.type = N'P' OR sp.type = N'RF' OR sp.type=N'PC')and(CAST( case WHEN sp.is_ms_shipped = 1 THEN 1 W
获取SQL Server数据库中所有的用户存储过程。SELECT SCHEMA_NAME(sp.schema_id) AS [Schema],sp.name AS [Name] FROM sys.all_objects AS sp WHERE (sp.type = N'P' OR sp.type = N'RF' OR sp.type=N'PC')and(CAST( case WHEN sp.is_ms_shipped = 1 THEN 1 WHEN ( SELECT major_id FROM sys.extended_properties WHERE major_id = sp.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') IS NOT NULL THEN 1 ELSE 0 END AS bit)=N'0') ORDER BY [Schema] ASC,[Name] ASC ? ? ?
上一篇: 常见的三种数据库数据模型是什么
下一篇: MySQL查看所有存储过程