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.

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

Community Additions

ADD
Show:
© 2014 Microsoft