Интерфейс ITableOptions

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

Этот API-интерфейс несовместим с CLS. В качестве CLS-совместимой альтернативы можно использовать .

Пространство имен:  Microsoft.SqlServer.Management.Smo
Сборка:  Microsoft.SqlServer.Smo (в Microsoft.SqlServer.Smo.dll)

Синтаксис

'Декларация
<StateChangeEventAttribute("CREATE_TABLE", "TABLE")> _
<LocalizedPropertyResourcesAttribute("Microsoft.SqlServer.Management.Smo.LocalizableResources")> _
<DisplayDescriptionKeyAttribute("ITableOptions_Desc")> _
<DisplayNameKeyAttribute("ITableOptions_Name")> _
<CLSCompliantAttribute(False)> _
<StateChangeEventAttribute("ALTER_TABLE", "TABLE")> _
<StateChangeEventAttribute("RENAME", "TABLE")> _
<StateChangeEventAttribute("ALTER_AUTHORIZATION_DATABASE", "TABLE")> _
<StateChangeEventAttribute("ALTER_SCHEMA", "TABLE")> _
<EvaluationModeAttribute(AutomatedPolicyEvaluationMode.None Or AutomatedPolicyEvaluationMode.Enforce Or AutomatedPolicyEvaluationMode.CheckOnChanges Or AutomatedPolicyEvaluationMode.CheckOnSchedule)> _
<TypeConverterAttribute(GetType(LocalizableTypeConverter))> _
Public Interface ITableOptions _
    Inherits IDmfFacet
'Применение
Dim instance As ITableOptions

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

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

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

public interface ITableOptions extends IDmfFacet

Тип ITableOptions обеспечивает доступ к следующим элементам.

Свойства

	Имя	Описание
	AnsiNullsStatus	Gets or sets the Boolean value that determines whether ISO null handling is enabled on the table.
	ChangeTrackingEnabled	Gets or sets the Boolean value that determines whether change tracking is enabled on the table.
	CreateDate	Gets the date and time when the table was created.
	FakeSystemTable	Gets the Boolean value that determines whether the table references a system table.
	ID	Gets the ID value that uniquely identifies the table.
	IsSchemaOwned	Gets the Boolean value that determines whether the table schema has an owner.
	IsSystemObject	Gets the Boolean value that determines whether the table is a system object.
	LockEscalation	Gets or sets the type of lock escalation implemented on the table.
	Name	Gets or sets the name of the table.
	Owner	Gets or sets the owner of the table options.
	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.
	Replicated	Gets the Boolean value that determines whether the table is replicated.
	Schema	Gets or sets the schema that is associated with the table options.
	TrackColumnsUpdatedEnabled	Gets the Boolean value that determines whether column updates in the table are tracked.

В начало

См. также

Справочник

Пространство имен Microsoft.SqlServer.Management.Smo