Aracılığıyla paylaş

UserDefinedDataType.Collation Property

  • Makale

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

'Bildirim
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property Collation As String
    Get
'Kullanım
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)