CaseSensitive Propiedad
Obtiene un valor de propiedad Boolean que especifica si las letras mayúsculas y minúsculas se evalúan como iguales.
Espacio de nombres: Microsoft.SqlServer.Management.Smo
Ensamblado: Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)
Sintaxis
'Declaración
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property CaseSensitive As Boolean
Get
'Uso
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
Valor de la propiedad
Tipo: System. . :: . .Boolean
Valor Boolean que especifica si las letras mayúsculas y minúsculas se evalúan como iguales.
Si es True, las letras mayúsculas y minúsculas no se evalúan como iguales. En caso contrario, es False (valor predeterminado).
Comentarios
This property specifies whether the collation associated with the database is case sensitive.
Ejemplos
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