How to Know Internal Details of any DB using Query.

How to know the list of procedures present in your DB

Select * from sys.procedures

SELECT NAME from SYS.PROCEDURES 
where name like '%CUSTOMER%'
order by name

How to Know the internal details of a Procedure

sp_depends procedureName

How to Know the internal details of a Table

sp_depends TableName

Select List of Table Names from any DB.

SELECT NAME from SYS.Tables
order by name

Select List of triggers from any DB.

SELECT NAME from SYS.Triggers
order by name

Select List of Views from any DB.

SELECT NAME from SYS.Views
order by name

Select List of Sequences
from any DB.

SELECT NAME from SYS.Sequences
order by name

Select List of Types
from any DB.
SELECT NAME from SYS.Types
order by name

Select List of Assemblies
from any DB.
SELECT NAME from SYS.Assemblies
order by name

Select List of Functions
from any DB.
SELECT ROUTINE_NAME FROM information_schema.routines WHERE routine_type = 'function'