| title | sys.assemblies (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/14/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine, sql-data-warehouse, pdw | ||||
| ms.reviewer | |||||
| ms.technology | system-objects | ||||
| ms.topic | language-reference | ||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | e321753f-293f-42ab-b225-d118713df40b | ||||
| author | stevestein | ||||
| ms.author | sstein | ||||
| monikerRange | >=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEtsql-appliesto-ss2008-xxxx-asdw-pdw-md]
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 |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
CLR Assembly Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL)