مشاركة عبر


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.

Examples

How to Get and Set a Property in Visual Basic .NET

See Also

Reference

IDatabaseOptions Interface

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Setting Properties

Database Options