title

sys.assemblies (Transact-SQL)

description

sys.assemblies (Transact-SQL)

author

rwestMSFT

ms.author

randolphwest

ms.date

03/14/2017

ms.service

sql

ms.subservice

system-objects

ms.topic

reference

f1_keywords

sys.assemblies

assemblies_TSQL

sys.assemblies_TSQL

assemblies

helpviewer_keywords

sys.assemblies catalog view

dev_langs

TSQL

monikerRange

>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||=fabric

sys.assemblies (Transact-SQL)

Returns a row for each assembly.

Column name	Data type	Description
name	sysname	Name of the assembly. Is unique within the database.
principal_id	int	ID of the principal that owns this assembly.
assembly_id	int	Assembly identification number. Is unique within a database.
clr_name	nvarchar(4000)	Canonical string that encodes the simple name, version number, culture, public key, and architecture of the assembly. This value uniquely identifies the assembly on the common language runtime (CLR) side.
permission_set	tinyint	Permission-set/security-level for assembly. 1 = Safe Access 2 = External Access 3 = Unsafe Access
permission_set_desc	nvarchar(60)	Description for permission-set/security-level for assembly. SAFE_ACCESS EXTERNAL_ACCESS UNSAFE_ACCESS
is_visible	bit	1 = Assembly is visible to register [!INCLUDEtsql] entry points. 0 = Assembly is intended only for managed callers. That is, the assembly provides internal implementation for other assemblies in the database.
create_date	datetime	Date the assembly was created or registered.
modify_date	datetime	Date the assembly was modified.
is_user_defined	bit	Indicates the source of the assembly. 0 = System-defined assemblies (such as Microsoft.SqlServer.Types for the hierarchyid data type) 1 = User-defined assemblies

Permissions