다음을 통해 공유

  • 아티클

CaseSensitive 속성

대문자와 소문자를 동일한 것으로 평가하는지 여부를 지정하는 Boolean 속성 값을 가져옵니다.

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

구문

‘선언
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public ReadOnly Property CaseSensitive As Boolean
    Get
‘사용 방법
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

속성 값

유형: System. . :: . .Boolean
대문자와 소문자를 동일한 것으로 평가하는지 여부를 지정하는 Boolean 값입니다.
True 이면 대문자와 소문자를 동일한 것으로 평가합니다. 그렇지 않으면 False(기본값)입니다.

주의

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 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