ITableOptions Interface

 
clsCompliantAlternative

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

This API is not CLS-compliant.

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

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

NameDescription
System_CAPS_pubpropertyAnsiNullsStatus

Gets or sets the Boolean value that determines whether ISO null handling is enabled on the table.

System_CAPS_pubpropertyChangeTrackingEnabled

Gets or sets the Boolean value that determines whether change tracking is enabled on the table.

System_CAPS_pubpropertyCreateDate

Gets the date and time when the table was created.

System_CAPS_pubpropertyFakeSystemTable

Gets the Boolean value that determines whether the table references a system table.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the table.

System_CAPS_pubpropertyIsSchemaOwned

Gets the Boolean value that determines whether the table schema has an owner.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean value that determines whether the table is a system object.

System_CAPS_pubpropertyLockEscalation

Gets or sets the type of lock escalation implemented on the table.

System_CAPS_pubpropertyName

Gets or sets the name of the table.

System_CAPS_pubpropertyOwner

Gets or sets the owner of the table options.

System_CAPS_pubpropertyQuotedIdentifierStatus

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.

System_CAPS_pubpropertyRemoteDataArchiveDataMigrationState
System_CAPS_pubpropertyRemoteDataArchiveEnabled

Gets or sets a value that indicates whether the remote data archive is enabled.

System_CAPS_pubpropertyRemoteTableName

Gets the remote table name for the table options.

System_CAPS_pubpropertyRemoteTableProvisioned

Gets a value whether the RemoteTable is provisioned.

System_CAPS_pubpropertyReplicated

Gets the Boolean value that determines whether the table is replicated.

System_CAPS_pubpropertySchema

Gets or sets the schema that is associated with the table options.

System_CAPS_pubpropertyTrackColumnsUpdatedEnabled

Gets the Boolean value that determines whether column updates in the table are tracked.

Return to top
Show: