This is quick and dirty with the While statement, but it works and returns a table organized by type, name, schema name, and table name.

-----------------------------------------------------------------------------------------

DECLARE @tblRoutine TABLE (ID INT, routine_name...