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