Propriété Database.CaseSensitive

Article
04/26/2013

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

Espace de noms : Microsoft.SqlServer.Management.Smo
Assembly : Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property CaseSensitive As Boolean 
    Get
'Utilisation
Dim instance As Database 
Dim value As Boolean 

value = instance.CaseSensitive

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

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

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member CaseSensitive : bool

function get CaseSensitive () : boolean

Valeur de propriété

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

Notes

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

Exemples

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

'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