• Article

ITableOptions Interface

The ITableOptions class is an interface that represents a collection of options that is associated with a table.

This API is not CLS-compliant. The CLS-compliant alternative is .

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

Syntax

'Declaration
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.Enforce Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<StateChangeEventAttribute("ALTER_SCHEMA", "TABLE")> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
<DisplayNameKeyAttribute("ITableOptions_Name")> _
<DisplayDescriptionKeyAttribute("ITableOptions_Desc")> _
<CLSCompliantAttribute(False)> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<StateChangeEventAttribute("CREATE_TABLE", "TABLE")> _
<StateChangeEventAttribute("ALTER_TABLE", "TABLE")> _
<StateChangeEventAttribute("RENAME", "TABLE")> _
<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "TABLE")> _
Public Interface ITableOptions _
    Inherits IDmfFacet
'Usage
Dim instance As ITableOptions

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.Enforce|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[StateChangeEventAttribute("ALTER_SCHEMA", "TABLE")]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute("ITableOptions_Name")]
[DisplayDescriptionKeyAttribute("ITableOptions_Desc")]
[CLSCompliantAttribute(false)]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[StateChangeEventAttribute("CREATE_TABLE", "TABLE")]
[StateChangeEventAttribute("ALTER_TABLE", "TABLE")]
[StateChangeEventAttribute("RENAME", "TABLE")]
[StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "TABLE")]
public interface ITableOptions : IDmfFacet

[EvaluationModeAttribute(AutomatedPolicyEvaluationMode::None|AutomatedPolicyEvaluationMode::Enforce|AutomatedPolicyEvaluationMode::CheckOnChanges|AutomatedPolicyEvaluationMode::CheckOnSchedule)]
[StateChangeEventAttribute(L"ALTER_SCHEMA", L"TABLE")]
[TypeConverterAttribute(typeof(LocalizableTypeConverter))]
[DisplayNameKeyAttribute(L"ITableOptions_Name")]
[DisplayDescriptionKeyAttribute(L"ITableOptions_Desc")]
[CLSCompliantAttribute(false)]
[LocalizedPropertyResourcesAttribute(L"Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[StateChangeEventAttribute(L"CREATE_TABLE", L"TABLE")]
[StateChangeEventAttribute(L"ALTER_TABLE", L"TABLE")]
[StateChangeEventAttribute(L"RENAME", L"TABLE")]
[StateChangeEventAttribute(L"ALTER_AUTHORIZATION_DATABASE", L"TABLE")]
public interface class ITableOptions : IDmfFacet

[<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None|AutomatedPolicyEvaluationMode.Enforce|AutomatedPolicyEvaluationMode.CheckOnChanges|AutomatedPolicyEvaluationMode.CheckOnSchedule)>]
[<StateChangeEventAttribute("ALTER_SCHEMA", "TABLE")>]
[<TypeConverterAttribute(typeof(LocalizableTypeConverter))>]
[<DisplayNameKeyAttribute("ITableOptions_Name")>]
[<DisplayDescriptionKeyAttribute("ITableOptions_Desc")>]
[<CLSCompliantAttribute(false)>]
[<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")>]
[<StateChangeEventAttribute("CREATE_TABLE", "TABLE")>]
[<StateChangeEventAttribute("ALTER_TABLE", "TABLE")>]
[<StateChangeEventAttribute("RENAME", "TABLE")>]
[<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "TABLE")>]
type ITableOptions =  
    interface
        interface IDmfFacet
    end

public interface ITableOptions extends IDmfFacet

The ITableOptions type exposes the following members.

Properties

  Name Description
Public property AnsiNullsStatus Gets or sets the Boolean value that determines whether ISO null handling is enabled on the table.
Public property ChangeTrackingEnabled Gets or sets the Boolean value that determines whether change tracking is enabled on the table.
Public property CreateDate Gets the date and time when the table was created.
Public property FakeSystemTable Gets the Boolean value that determines whether the table references a system table.
Public property ID Gets the ID value that uniquely identifies the table.
Public property IsSchemaOwned Gets the Boolean value that determines whether the table schema has an owner.
Public property IsSystemObject Gets the Boolean value that determines whether the table is a system object.
Public property LockEscalation Gets or sets the type of lock escalation implemented on the table.
Public property Name Gets or sets the name of the table.
Public property Owner Gets or sets the owner of the table options.
Public property QuotedIdentifierStatus Gets or sets the Boolean value that determines whether identifiers delimited by double quotation marks are Transact-SQL reserved keywords or contain characters not usually allowed by the Transact-SQL syntax rules.
Public property Replicated Gets the Boolean value that determines whether the table is replicated.
Public property Schema Gets or sets the schema that is associated with the table options.
Public property TrackColumnsUpdatedEnabled Gets the Boolean value that determines whether column updates in the table are tracked.

Top