UserDefinedDataType.Collation Property

Gets the collation assigned to the user-defined data type.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property Collation As String 
    Get
'Usage
Dim instance As UserDefinedDataType 
Dim value As String 

value = instance.Collation

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public string Collation { get; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property String^ Collation {
    String^ get ();
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member Collation : string

function get Collation () : String

Property Value

Type: System.String
A String value that specifies the collation used by the user-defined data type.

Remarks

The default collation is defined at a Server object level; however, individual columns and user-defined data types can have specific collations. A table that contains columns in languages with different alphabets require different collations on different columns, for example.

Examples

Working with Data Types

See Also

Reference

UserDefinedDataType Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Data Types (Database Engine)

CREATE TYPE (Transact-SQL)