sys.assemblies (Transact-SQL)
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)
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για