Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |