.png)
Database.CaseSensitive Property
SQL Server 2008 R2
Gets a Boolean property value that specifies whether uppercase letters and lowercase letters are evaluated as equal.
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)] public bool CaseSensitive { get; }
Property Value
Type: System.BooleanA 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).
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 AdventureWorks2008R2 database.
Dim db As Database
db = srv.Databases("AdventureWorks2008R2")
'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("AdventureWorks2008R2")
Write-Host "The database is case sensitive =" $db.CaseSensitive
