Listar procedures, views e functions

Listar procedures, views e funções existentes no database selecionado utilizando o SQLServer

SELECT

name AS ObjectName,

schema_name(schema_id) AS SchemaName,

type_desc AS ObjectType,

create_date,

modify_date

FROM

sys.objects

WHERE

type IN ('P', 'V', 'FN') -- 'P' para Procedures, 'V' para Views, 'FN' para Functions

ORDER BY

SchemaName,

ObjectName;