get list with procedures, functions or views in Sql

How to get list with procedures, functions or views in Sql?

In order to obtain a list with procedures(P), functions(FN) or views(V) in Sql you can run this query:

SELECT [name], [type], create_date, modify_date

 

FROM sys.objects

 

WHERE [type] in ('P', 'FN', 'V')

 

order by [Type ] asc