- 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
- --该片段来自于http://www.codesnippet.cn/detail/1108201513402.html
来源: http://www.codesnippet.cn/detail/1108201513402.html