Export (0) Print
Expand All

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.

Applies to: SQL Server (SQL Server 2008 through current version).

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft