title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

f1_keywords

helpviewer_keywords

dev_langs

monikerRange

sys.assemblies (Transact-SQL)

rwestMSFT

randolphwest

03/14/2017

sql

system-objects

reference

sys.assemblies

assemblies_TSQL

sys.assemblies_TSQL

assemblies

sys.assemblies catalog view

TSQL

>=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