ITableOptions ITableOptions ITableOptions Interface

Definition

Important

This API is not CLS-compliant.

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

public interface class ITableOptions : Microsoft::SqlServer::Management::Sdk::Sfc::IDmfFacet
[Microsoft.SqlServer.Management.Facets.EvaluationMode(Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.Enforce | Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnChanges | Microsoft.SqlServer.Management.Dmf.AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("RENAME", "TABLE")]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("CREATE_TABLE", "TABLE")]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("ALTER_TABLE", "TABLE")]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("ALTER_AUTHORIZATION_DATABASE", "TABLE")]
[Microsoft.SqlServer.Management.Facets.StateChangeEvent("ALTER_SCHEMA", "TABLE")]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayDescriptionKey("ITableOptions_Desc")]
[Microsoft.SqlServer.Management.Sdk.Sfc.DisplayNameKey("ITableOptions_Name")]
[Microsoft.SqlServer.Management.Sdk.Sfc.LocalizedPropertyResources("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[System.CLSCompliant(false)]
[System.ComponentModel.TypeConverter(typeof(Microsoft.SqlServer.Management.Sdk.Sfc.LocalizableTypeConverter))]
public interface ITableOptions : Microsoft.SqlServer.Management.Sdk.Sfc.IDmfFacet
Public Interface ITableOptions
Implements IDmfFacet
Derived
Attributes
Microsoft.SqlServer.Management.Facets.EvaluationModeAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute Microsoft.SqlServer.Management.Facets.StateChangeEventAttribute DisplayDescriptionKeyAttribute DisplayNameKeyAttribute LocalizedPropertyResourcesAttribute CLSCompliantAttribute TypeConverterAttribute
Implements

Properties

AnsiNullsStatus AnsiNullsStatus AnsiNullsStatus

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

ChangeTrackingEnabled ChangeTrackingEnabled ChangeTrackingEnabled

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

CreateDate CreateDate CreateDate

Gets the date and time when the table was created.

FakeSystemTable FakeSystemTable FakeSystemTable

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

ID ID ID

Gets the ID value that uniquely identifies the table.

IsSchemaOwned IsSchemaOwned IsSchemaOwned

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

IsSystemObject IsSystemObject IsSystemObject

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

LockEscalation LockEscalation LockEscalation

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

Name Name Name

Gets or sets the name of the table.

Owner Owner Owner

Gets or sets the owner of the table options.

QuotedIdentifierStatus QuotedIdentifierStatus 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.

RemoteDataArchiveDataMigrationState RemoteDataArchiveDataMigrationState RemoteDataArchiveDataMigrationState

Gets or sets the RemoteDataArchiveMigrationState.

RemoteDataArchiveEnabled RemoteDataArchiveEnabled RemoteDataArchiveEnabled

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

RemoteTableName RemoteTableName RemoteTableName

Gets the remote table name for the table options.

RemoteTableProvisioned RemoteTableProvisioned RemoteTableProvisioned

Gets a value whether the RemoteTable is provisioned.

Replicated Replicated Replicated

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

Schema Schema Schema

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

TrackColumnsUpdatedEnabled TrackColumnsUpdatedEnabled TrackColumnsUpdatedEnabled

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

Applies to