Dela via

  • Artikel

IDatabaseOptions.QuotedIdentifiersEnabled Property

Gets or sets a Boolean property value that specifies whether identifiers delimited by double quotation marks (" ") are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
<DisplayNameKeyAttribute("Database_QuotedIdentifiersEnabledName")> _
<DisplayDescriptionKeyAttribute("Database_QuotedIdentifiersEnabledDesc")> _
Property QuotedIdentifiersEnabled As Boolean
    Get
    Set
'Usage
Dim instance As IDatabaseOptions
Dim value As Boolean

value = instance.QuotedIdentifiersEnabled

instance.QuotedIdentifiersEnabled = value

[DisplayNameKeyAttribute("Database_QuotedIdentifiersEnabledName")]
[DisplayDescriptionKeyAttribute("Database_QuotedIdentifiersEnabledDesc")]
bool QuotedIdentifiersEnabled { get; set; }

[DisplayNameKeyAttribute(L"Database_QuotedIdentifiersEnabledName")]
[DisplayDescriptionKeyAttribute(L"Database_QuotedIdentifiersEnabledDesc")]
property bool QuotedIdentifiersEnabled {
    bool get ();
    void set (bool value);
}

[<DisplayNameKeyAttribute("Database_QuotedIdentifiersEnabledName")>]
[<DisplayDescriptionKeyAttribute("Database_QuotedIdentifiersEnabledDesc")>]
abstract QuotedIdentifiersEnabled : bool with get, set

function get QuotedIdentifiersEnabled () : boolean
function set QuotedIdentifiersEnabled (value : boolean)

Property Value

Type: System.Boolean
A Boolean value that specifies whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
If True, identifiers delimited by double quotation marks are interpreted as object identifiers.
If False, identifiers delimited by double quotation marks are strings that contain characters not usually allowed by the Transact-SQL syntax rules, such as apostrophes.

Remarks

This option can also be changed by using the Transact-SQL ALTER DATABASE statement.