Edit

sys.assemblies (Transact-SQL)

  • Article

Applies to: SQL Server Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

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 Transact-SQL 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

The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration.

See Also

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