sys-assembly-files-transact-sql.md

title	sys.assembly_files (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sys.assembly_files assembly_files_TSQL assembly_files sys.assembly_files_TSQL
dev_langs	TSQL
helpviewer_keywords	sys.assembly_files catalog view
ms.assetid	1a384a2c-5556-4d12-a2ba-4da781363143
author	stevestein
ms.author	sstein

sys.assembly_files (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Contains a row for each file that makes up an assembly.

Column name	Data type	Description
assembly_id	int	ID of the assembly to which this file belongs.
name	nvarchar(260)	Name of the assembly file.
file_id	int	ID of the file. Is unique within an assembly. The file ID numbered 1 represents the assembly DLL.
content	varbinary(max)	Content of file.

Permissions

[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.

See Also

CLR Assembly Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL)