문서를 영문으로 보려면 영문 확인란을 선택하세요. 마우스 포인터를 텍스트 위로 이동시켜 팝업 창에서 영문 텍스트를 표시할 수도 있습니다.
번역
영문

Database.CaseSensitive 속성

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

네임스페이스:  Microsoft.SqlServer.Management.Smo
어셈블리:  Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)

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

속성 값

유형: 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).

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

커뮤니티 추가 항목

추가
표시: