获取SQL Server数据库中所有的用户存储过程
- 作者: 謀謀朲69206536
- 来源: 51数据库
- 2022-08-17
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
?
?
?
推荐阅读
