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)