Condividi tramite

  • Articolo

Proprietà CaseSensitive

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

Spazio dei nomi:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<SfcPropertyAttribute> _
Public ReadOnly Property CaseSensitive As Boolean
    Get
'Utilizzo
Dim instance As Database
Dim value As Boolean

value = instance.CaseSensitive

[SfcPropertyAttribute]
public bool CaseSensitive { get; }

[SfcPropertyAttribute]
public:
property bool CaseSensitive {
    bool get ();
}

[<SfcPropertyAttribute>]
member CaseSensitive : bool

function get CaseSensitive () : boolean

Valore proprietà

Tipo: 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).

Osservazioni

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

Esempi

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 AdventureWorks database.
Dim db As Database
db = srv.Databases("AdventureWorks")

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