Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.

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

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.

Community Additions

ADD
Show:
© 2015 Microsoft