Condividi tramite


Interfaccia ITableOptions

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

Questa API non è conforme a CLS. L'alternativa conforme a CLS è .

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
<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
'Utilizzo
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

Nel tipo ITableOptions sono esposti i membri seguenti.

Proprietà

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

In alto