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 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
In SQL Server 2005 and later versions, the visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.