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

Related content

• Assemblies (Database Engine)
• Designing assemblies
• Implementing assemblies