The following commands will assist in retrieving the metadata details regarding the system-created views. SELECT * FROM sys.objects WHERE type = ‘V’ Or you can
Tag: INFORMATION_SCHEMA in SQL Server
SQL Server – List-out Procedures, Functions, Triggers
In order to know which procedures, functions, and triggers exist in the database, the following queries can help you to find this out.: The below