SELECT * FROM sys.all_objects
WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC')
AND [is_ms_shipped] = 1
ORDER BY [name];
To find functions, use type of >
FN SQL Scalar Function
IF Inline Table Valued Function
TF SQL Table Valued Function
To find views, use type of >
V View
To find procedures, use type of >
P SQL Stored Procedure
PC CLR Stored Procedure
X Extended Stored Procedure
No comments:
Post a Comment