Share via

DatabaseOptions.QuotedIdentifiersEnabled Property

  • Article

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
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property QuotedIdentifiersEnabled As Boolean 
    Get 
    Set
'Usage
Dim instance As DatabaseOptions 
Dim value As Boolean 

value = instance.QuotedIdentifiersEnabled

instance.QuotedIdentifiersEnabled = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool QuotedIdentifiersEnabled { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool QuotedIdentifiersEnabled {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member 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.

Examples

Setting Properties

See Also

Reference

DatabaseOptions Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Database Options