Database.CaseSensitive Database.CaseSensitive Database.CaseSensitive Property

Definition

Gets a value that specifies whether uppercase letters and lowercase letters are evaluated as equal.

public:
 property bool CaseSensitive { bool get(); };
[Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcProperty(Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Expensive | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.Standalone | Microsoft.SqlServer.Management.Sdk.Sfc.Metadata.SfcPropertyFlags.SqlAzureDatabase)]
public bool CaseSensitive { get; }
Public ReadOnly Property CaseSensitive As Boolean
Property Value

A Boolean value that specifies whether uppercase letters and lowercase letters are evaluated as equal.

If True, uppercase and lowercase are not evaluated as equal. Otherwise, False (default).

Examples

The CaseSensitive property is a Boolean property that will return True or False in the following code:

VB

'Connect to the local, default instance of SQL Server.  
Dim srv As Server  
srv = New Server  

'Reference the AdventureWorks2012 database.  
Dim db As Database  
db = srv.Databases("AdventureWorks2012")  

'Display the case sensitivity of the database.  
Console.WriteLine("The database is case sensitive = " + _  
db.CaseSensitive.ToString)  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  
$db = New-Object Microsoft.SqlServer.Management.Smo.Database  
$db = $srv.Databases.Item("AdventureWorks2012")  
Write-Host "The database is case sensitive =" $db.CaseSensitive  

Remarks

This property specifies whether the collation associated with the database is case sensitive.

Applies to