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. |
See Also
Reference
CLR Assembly Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL)
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
5 December 2005 |
|