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 |