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 |
|
|