---
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
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
  The following catalog views and functions can be queried for metadata about assemblies.  
  
 **To get information about individual assemblies**  
  
-   [ASSEMBLYPROPERTY (Transact-SQL)](../../t-sql/functions/assemblyproperty-transact-sql.md)  
  
 **To get information about all assemblies in the database**  
  
-   [sys.assemblies (Transact-SQL)](../../relational-databases/system-catalog-views/sys-assemblies-transact-sql.md)  
  
 **To get information about assembly files, including assembly binaries, source files, and debug files**  
  
-   [sys.assembly_files (Transact-SQL)](../../relational-databases/system-catalog-views/sys-assembly-files-transact-sql.md)  
  
 **To get information about cross-assembly references**  
  
-   [sys.assembly_references (Transact-SQL)](../../relational-databases/system-catalog-views/sys-assembly-references-transact-sql.md)  
  
 **To get assembly information about user-defined types**  
  
-   [sys.assembly_types (Transact-SQL)](../../relational-databases/system-catalog-views/sys-assembly-types-transact-sql.md)  
  
-   [sys.types (Transact-SQL)](../../relational-databases/system-catalog-views/sys-types-transact-sql.md)  
  
 **To get assembly information about common language runtime (CLR) stored procedures, triggers, and functions**  
  
-   [sys.assembly_modules (Transact-SQL)](../../relational-databases/system-catalog-views/sys-assembly-modules-transact-sql.md)  
  
 **To get information about non-CLR objects**  
  
-   [sys.sql_modules (Transact-SQL)](../../relational-databases/system-catalog-views/sys-sql-modules-transact-sql.md)  
  
## See Also  
 [Assemblies (Database Engine)](../../relational-databases/clr-integration/assemblies-database-engine.md)   
 [Designing Assemblies](../../relational-databases/clr-integration/assemblies-designing.md)   
 [Implementing Assemblies](../../relational-databases/clr-integration/assemblies-implementing.md)