sys.assembly_types (Transact-SQL)

Contains a row for each user-defined type that is defined by a CLR assembly.

Column name	Data type	Description
<inherited columns>		Inherits columns from sys.types. For a list of inherited columns, see sys.types (Transact-SQL)
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().

See Also