Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
Applies to: SQL Server (SQL Server 2008 through current version), Azure SQL Data Warehouse Public Preview.
ID of the assembly from which this type was created.
Name of the class within the assembly that defines this type.
Sorting the bytes of this type is equivalent to sorting using comparison operators on the type.
Length of the type is always the same as max_length.
ProgID of the type as exposed to COM.
Assembly qualified type name. The name is in a format suitable to be passed to Type.GetType().
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.