Server.EnumCollations Server.EnumCollations Server.EnumCollations Method

Definition

Enumerates a list of collations supported by the instance of SQL Server.

public:
 System::Data::DataTable ^ EnumCollations();
public System.Data.DataTable EnumCollations ();
Public Function EnumCollations () As DataTable
Returns

A DataTable object value that contains the collation information. The table describes the different columns of the returned DataTable.

Column
Data type
Description
Urn
String The URN string that identifies the collation.
Name
String The name of the collation. See sys.fn_helpcollations (Transact-SQL).
CodePage
Int32 The code page of the collation. See Collation and Code Page Architecture.
LocaleID
Int32 The locale of the collation. See sys.syslanguages (Transact-SQL).
ComparisonStyle
Int32 The comparison style made up of the sum of the following styles, Case insensitivity = 1, Accent insensitivity = 2, Kana type insensitivity = 64436, Width insensitivity = 131072.
Description
String The description of the collation.

Examples

C#

Server srv = new Server("(local)");  

DataTable d = srv.EnumCollations();  
foreach (DataRow r in d.Rows)  
{  
   Console.WriteLine("============================================");  
   foreach(DataColumn c in d.Columns)  
   {  
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());  
   }  
}  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  

$d = new-object System.Data.Datatable  
$d = $srv.EnumCollations()  

Foreach ($r in $d.Rows)  
{  
   Write-Host "============================================"  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c]  
   }  
}  

Applies to