sys.assembly_types (Transact-SQL)
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
In SQL Server 2005 and later versions, 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.