How to use Information Schema on procedures and functions in SQL Server. (Part 2 of 2)

Description:
This video looks at the Procedure, scalar functions and table-valued functions as information schema would see them. We will use 3 views to inspect the internal setting of these programmability objects.

How to use Object_Definition to view the SQL of any of the information_schema views.

How to get the output parameters from a Stored Procedure.


@@@@@@@@@@@@@@@@@@@@@@@@@@@
Hey Team,

I hope this video was beneficial and will assist you make the following decision.

I would appreciate if you could leave a message for other students to read, a thumbs up if you learned something new and enjoyed the video, and please consider subscribing to this channel. Thank you in advance for your consideration.

Let's help each other!
@@@@@@@@@@@@@@@@@@@@@@@@@@@


Time Line
00:00 beginning
00:42 - Introduction to Information_schema views
01:09 - Did you know?
02:43 - INFORMATION_SCHEMA.ROUTINES
04:22 - INFORMATION_SCHEMA.PARAMETERS
06:54 - Scalar-Valued functions
09:16 - procedures
11:26 - output from procedure
15:53 - motiviation from scott

sys.objects
object_definition
object_id
information_schema.routines
information_schema.parameters
information_schema.routine_columns
software nuggets