assemblies-getting-information.md

title	Getting Information About Assemblies | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql
ms.reviewer
ms.technology
ms.topic	reference
helpviewer_keywords	assemblies [CLR integration], metadata status information [SQL Server], assemblies metadata [SQL Server], assemblies
ms.assetid	6aa7f18e-baad-4481-9777-8c3b230b392f
author	rothja
ms.author	jroth

Assemblies - Getting Information

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] The following catalog views and functions can be queried for metadata about assemblies.

To get information about individual assemblies

• ASSEMBLYPROPERTY (Transact-SQL)

To get information about all assemblies in the database

• sys.assemblies (Transact-SQL)

To get information about assembly files, including assembly binaries, source files, and debug files

• sys.assembly_files (Transact-SQL)

To get information about cross-assembly references

• sys.assembly_references (Transact-SQL)

To get assembly information about user-defined types

• sys.assembly_types (Transact-SQL)

• sys.types (Transact-SQL)

To get assembly information about common language runtime (CLR) stored procedures, triggers, and functions

• sys.assembly_modules (Transact-SQL)

To get information about non-CLR objects

• sys.sql_modules (Transact-SQL)

See Also

Assemblies (Database Engine)
Designing Assemblies
Implementing Assemblies