We need the metadata of all functions and procedures(all user defined, all system functions, agg functions , inline functions, scalar functions etc) using Information_schema?
I tried joining select * from information_schema.routines, select * from information_schema.parameters.
But its giving only functions from dbo schema.
I want all functions from dbo and sys both and that too using INFORMATION_SCHEMA.
