TechNet
Export (0) Print
Expand All

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(typeof(LocalizableTypeConverter))]
[EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None | AutomatedPolicyEvaluationMode.Enforce | AutomatedPolicyEvaluationMode.CheckOnChanges | AutomatedPolicyEvaluationMode.CheckOnSchedule)]
[LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")]
[StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "TABLE")]
[StateChangeEventAttribute("ALTER_SCHEMA", "TABLE")]
public interface ITableOptions : 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

System_CAPS_pubpropertyRemoteTableName

System_CAPS_pubpropertyRemoteTableProvisioned

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:
© 2016 Microsoft