| title | Get Information About Assemblies | |||
|---|---|---|---|---|
| description | Learn how to get information about assemblies using catalog views and functions. | |||
| author | rwestMSFT | |||
| ms.author | randolphwest | |||
| ms.date | 12/27/2024 | |||
| ms.service | sql | |||
| ms.topic | reference | |||
| helpviewer_keywords |
|
[!INCLUDE 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 |