sys.assembly_types (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
Contains a row for each user-defined type that is defined by a CLR assembly. The following sys.assembly_types appear in the list of inherited columns (see sys.types (Transact-SQL)) after rule_object_id.
Column name | Data type | Description |
---|---|---|
assembly_id | int | ID of the assembly from which this type was created. |
assembly_class | sysname | Name of the class within the assembly that defines this type. |
is_binary_ordered | bit | Sorting the bytes of this type is equivalent to sorting using comparison operators on the type. |
is_fixed_length | bit | Length of the type is always the same as max_length. |
prog_id | nvarchar(40) | ProgID of the type as exposed to COM. |
assembly_qualified_name | nvarchar(4000) | Assembly qualified type name. The name is in a format suitable to be passed to Type.GetType(). |
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
Catalog Views (Transact-SQL)
Scalar Types Catalog Views (Transact-SQL)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें