---
title: "Getting Information About Assemblies | Microsoft Docs"
ms.custom: ""
ms.date: "03/06/2017"
ms.prod: "sql-server-2014"
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
manager: craigg
---
# Getting Information About Assemblies
  The following catalog views and functions can be queried for metadata about assemblies.  
  
 **To get information about individual assemblies**  
  
-   [ASSEMBLYPROPERTY (Transact-SQL)](/sql/t-sql/functions/assemblyproperty-transact-sql)  
  
 **To get information about all assemblies in the database**  
  
-   [sys.assemblies (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-assemblies-transact-sql)  
  
 **To get information about assembly files, including assembly binaries, source files, and debug files**  
  
-   [sys.assembly_files (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-assembly-files-transact-sql)  
  
 **To get information about cross-assembly references**  
  
-   [sys.assembly_references (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-assembly-references-transact-sql)  
  
 **To get assembly information about user-defined types**  
  
-   [sys.assembly_types (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-assembly-types-transact-sql)  
  
-   [sys.types (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-types-transact-sql)  
  
 **To get assembly information about common language runtime (CLR) stored procedures, triggers, and functions**  
  
-   [sys.assembly_modules (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-assembly-modules-transact-sql)  
  
 **To get information about non-CLR objects**  
  
-   [sys.sql_modules (Transact-SQL)](/sql/relational-databases/system-catalog-views/sys-sql-modules-transact-sql)  
  
## See Also  
 [Assemblies (Database Engine)](../../relational-databases/clr-integration/assemblies-database-engine.md)   
 [Designing Assemblies](../../relational-databases/clr-integration/assemblies-designing.md)   
 [Implementing Assemblies](assemblies-implementing.md)