Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
sys.assemblies (Transact-SQL)
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
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)
Feedback
Was this page helpful?