Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Database.CaseSensitive Property

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Matrix)]
public bool CaseSensitive { get; }

Property Value

Type: Boolean
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).

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

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

Community Additions

Show:
© 2015 Microsoft