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