Partilhar via


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
Public ReadOnly Property Collation As String
public string Collation { get; }
public:
property String^ Collation {
    String^ get ();
}
/** @property */
public String get_Collation ()
public function get Collation () : String

Property Value

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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Construct a DataType Object by Using the Default Constructor in Visual Basic .NET

How to: Construct a DataType Object with the Specification in the Constructor in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

UserDefinedDataType Class
UserDefinedDataType Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Data Types (Database Engine)
CREATE TYPE (Transact-SQL)