Sdílet prostřednictvím


Database.QuotedIdentifiersEnabled Property

Gets or sets a 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.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property QuotedIdentifiersEnabled As Boolean 
    Get 
    Set
'Usage
Dim instance As Database 
Dim value As Boolean 

value = instance.QuotedIdentifiersEnabled

instance.QuotedIdentifiersEnabled = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool QuotedIdentifiersEnabled { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
virtual property bool QuotedIdentifiersEnabled {
    bool get () sealed;
    void set (bool value) sealed;
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
abstract QuotedIdentifiersEnabled : bool with get, set
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
override QuotedIdentifiersEnabled : bool with get, set
final function get QuotedIdentifiersEnabled () : boolean 
final 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 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.

Implements

IDatabaseOptions.QuotedIdentifiersEnabled

Remarks

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

See Also

Reference

Database Class

Microsoft.SqlServer.Management.Smo Namespace