Get information about assemblies

Applies to: SQL Server

The following catalog views and functions can be queried for metadata about Common language runtime (CLR) assemblies.

Information Article
Individual assemblies ASSEMBLYPROPERTY
All assemblies in the database sys.assemblies
Assembly files, including assembly binaries, source files, and debug files sys.assembly_files
Cross-assembly references sys.assembly_references
User-defined types sys.assembly_types
sys.types
CLR stored procedures, triggers, and functions sys.assembly_modules
To get information about non-CLR objects sys.sql_modules