Compartir a través de

  • Artículo

Interfaz ITableOptions

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

Esta API no es compatible con CLS. La alternativa compatible con CLS es .

Espacio de nombres:  Microsoft.SqlServer.Management.Smo
Ensamblado:  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Sintaxis

'Declaración
<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
'Uso
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

El tipo ITableOptions expone los siguientes miembros.

Propiedades

  Nombre Descripción
Propiedad pública AnsiNullsStatus Gets or sets the Boolean value that determines whether ISO null handling is enabled on the table.
Propiedad pública ChangeTrackingEnabled Gets or sets the Boolean value that determines whether change tracking is enabled on the table.
Propiedad pública CreateDate Gets the date and time when the table was created.
Propiedad pública FakeSystemTable Gets the Boolean value that determines whether the table references a system table.
Propiedad pública ID Gets the ID value that uniquely identifies the table.
Propiedad pública IsSchemaOwned Gets the Boolean value that determines whether the table schema has an owner.
Propiedad pública IsSystemObject Gets the Boolean value that determines whether the table is a system object.
Propiedad pública LockEscalation Gets or sets the type of lock escalation implemented on the table.
Propiedad pública Name Gets or sets the name of the table.
Propiedad pública Owner Gets or sets the owner of the table options.
Propiedad pública 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.
Propiedad pública Replicated Gets the Boolean value that determines whether the table is replicated.
Propiedad pública Schema Gets or sets the schema that is associated with the table options.
Propiedad pública TrackColumnsUpdatedEnabled Gets the Boolean value that determines whether column updates in the table are tracked.

Arriba