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().|
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.