TableViewBase-Klasse
The TableViewBase class is a base class that is used in the construction of the Table class and View class. It contains functionality that is common to both classes.
Vererbungshierarchie
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Smo.ScriptNameObjectBase
Microsoft.SqlServer.Management.Smo.ScriptSchemaObjectBase
Microsoft.SqlServer.Management.Smo.TableViewTableTypeBase
Microsoft.SqlServer.Management.Smo.TableViewBase
Microsoft.SqlServer.Management.Smo.Table
Microsoft.SqlServer.Management.Smo.View
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
Public Class TableViewBase _
Inherits TableViewTableTypeBase _
Implements IExtendedProperties, IScriptable
'Usage
Dim instance As TableViewBase
public class TableViewBase : TableViewTableTypeBase,
IExtendedProperties, IScriptable
public ref class TableViewBase : public TableViewTableTypeBase,
IExtendedProperties, IScriptable
type TableViewBase =
class
inherit TableViewTableTypeBase
interface IExtendedProperties
interface IScriptable
end
public class TableViewBase extends TableViewTableTypeBase implements IExtendedProperties, IScriptable
Der TableViewBase-Typ macht folgende Elemente verfügbar.
Konstruktoren
| Name | Beschreibung | |
|---|---|---|
.gif "Geschützte Methode") |
TableViewBase | Initializes a new instance of the TableViewBase class. |
Zum Anfang
Eigenschaften
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliche Eigenschaft") |
Columns | Gets a column collection. (Geerbt von TableViewTableTypeBase.) |
.gif "Geschützte Eigenschaft") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Geerbt von SqlSmoObject.) |
|
ExtendedProperties | Gets an extended property collection. (Geerbt von TableViewTableTypeBase.) |
|
FullTextIndex | Gets the full text index on the table or view. |
|
Indexes | Gets an index collection. (Geerbt von TableViewTableTypeBase.) |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (Geerbt von SqlSmoObject.) |
|
Name | Gets or sets a String value that specifies the name of the view table type. (Geerbt von TableViewTableTypeBase.) |
|
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation, or whether it is directly or indirectly connected to the instance of SQL Server. (Geerbt von SqlSmoObject.) |
|
Properties | Gets a collection of Property objects that represent the object properties. (Geerbt von SqlSmoObject.) |
|
ScalarResult | Gets the scalar result for the referenced object. (Geerbt von SqlSmoObject.) |
|
Schema | Gets or sets a String value that specifies the name of the schema that contains the view table type. (Geerbt von TableViewTableTypeBase.) |
|
State | Gets the state of the referenced object. (Geerbt von SmoObjectBase.) |
|
Statistics | Represents a collection of Statistic objects. Each Statistic object represents a statistic counter that is defined on the table or view. |
|
Triggers | Represents a collection of Trigger objects. Each Trigger object represents a trigger that is defined on the table or view. |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Geerbt von SqlSmoObject.) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (Geerbt von SmoObjectBase.) |
Zum Anfang
Methoden
| Name | Beschreibung | |
|---|---|---|
|
AddDatabaseContext | Add the database context to the collection of queries identified by the queries parameter. (Geerbt von SqlSmoObject.) |
|
AlterImpl | Activates the object altered event. (Geerbt von SqlSmoObject.) |
|
AlterImplWorker | Calls the Alter methods. (Geerbt von SqlSmoObject.) |
|
AppendCommaText | Appends text, optionally separated by a comma. (Geerbt von ScriptNameObjectBase.) |
|
AppendWithCommaText | Appends text, optionally separated by a comma. (Geerbt von ScriptNameObjectBase.) |
|
AppendWithOption | Appends text and option text separated from the main text with a “WITH” string and optionally separated by a comma. (Geerbt von ScriptNameObjectBase.) |
|
AutoGenerateName | Generates a name based on the object Guid. (Geerbt von ScriptNameObjectBase.) |
|
BindDefaultImpl | Binds the default items identified by the parameters. (Geerbt von SqlSmoObject.) |
|
BindRuleImpl | Binds the rule schema to the rule and columns identified by the parameters. (Geerbt von SqlSmoObject.) |
|
CheckObjectDirty | Checks whether object has been modified and not persisted. (Geerbt von ScriptNameObjectBase.) |
|
CheckObjectState() | Validates the state of the referenced object. (Geerbt von SqlSmoObject.) |
|
CheckObjectState(Boolean) | Validates the state of the referenced object with the option to specify that an exception is thrown if the object is not yet created. (Geerbt von SqlSmoObject.) |
|
CheckObjectStateImpl | Checks the state of a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
CheckTextCorectness | Checks text for correctness against the parameters. (Geerbt von ScriptNameObjectBase.) |
|
CheckTextModeSupport | Checks mode of support. (Geerbt von ScriptNameObjectBase.) |
|
CheckVersion100 | Checks whether version of SQL Server is SQL Server 2008. (Geerbt von SqlSmoObject.) |
|
CheckVersion110() | Checks whether version of SQL Server is SQL Server 2012. (Geerbt von SqlSmoObject.) |
|
CheckVersion110(String) | Checks whether the version of SQL Server is SQL Server 2012 with the specified name. (Geerbt von SqlSmoObject.) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (Geerbt von SqlSmoObject.) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (Geerbt von SqlSmoObject.) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (Geerbt von SqlSmoObject.) |
|
CheckVersionBelow110 | Checks whether version of SQL Server is before SQL Server 2012. (Geerbt von SqlSmoObject.) |
|
CheckVersionBelow90 | Checks whether version of SQL Server is before SQL Server 2005. (Geerbt von SqlSmoObject.) |
|
CleanObject | Cleans the referenced object. (Geerbt von ScriptNameObjectBase.) |
|
CreateImpl | Creates an object with scripting options. (Geerbt von SqlSmoObject.) |
.gif "Öffentliche Methode") |
Discover | Discovers a list of type Object. (Geerbt von SqlSmoObject.) |
|
DropImpl | Drops a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
DropImplWorker | Calls the drop methods. (Geerbt von SqlSmoObject.) |
|
EnumFragmentation() | Enumerates information about fragments of data that are stored in a table or view. |
|
EnumFragmentation(FragmentationOption) | Enumerates information about fragments of data that are stored in a table or view with the option to specify how detailed the results should be. |
|
EnumFragmentation(FragmentationOption, Int32) | Enumerates information about fragments of data that are stored in a table or view on a specified partition, and with the option to specify how detailed the results should be. |
|
Equals | (Geerbt von Object.) |
|
ExecuteNonQuery | Executes a batch of statements that does not return a result set. (Geerbt von SqlSmoObject.) |
|
ExecuteRenameQuery | Executes the rename query for the object. (Geerbt von NamedSmoObject.) |
|
Finalize | (Geerbt von Object.) |
|
ForceTextModeOnTextBody | Enforces text mode on the text body. (Geerbt von ScriptNameObjectBase.) |
|
FormatSqlVariant | Formats an object as SqlVariant type. (Geerbt von SqlSmoObject.) |
|
GenerateAlterEvent() | Generates the alter event with the specified value. (Geerbt von SqlSmoObject.) |
|
GenerateAlterEvent(Urn, Object) | Generates alter event with the specified URN and inner object value. (Geerbt von SqlSmoObject.) |
|
GetBraketNameForText | Gets the bracket name for the text. (Geerbt von ScriptNameObjectBase.) |
|
GetContextDB | Gets the context database that is associated with this object. (Geerbt von SqlSmoObject.) |
|
GetDBName | Gets the database name that is associated with the object. (Geerbt von SqlSmoObject.) |
|
GetFragOptionString | Gets a FragmentationOption object as a string value. (Geerbt von SqlSmoObject.) |
|
GetHashCode | (Geerbt von Object.) |
|
GetIsSystemNamed | Gets a Boolean value that specifies whether the system is named. (Geerbt von ScriptNameObjectBase.) |
|
GetIsTextDirty | Determines whether the text value is consistent with stored value. (Geerbt von ScriptNameObjectBase.) |
|
GetPropValue | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetPropValueOptional | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetPropValueOptionalAllowNull | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetRealValue | Gets a property value of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.) |
|
GetServerObject | Gets the server of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (Geerbt von SqlSmoObject.) |
|
GetTextBody() | Returns the text body. (Geerbt von ScriptNameObjectBase.) |
|
GetTextBody(Boolean) | Returns the text body. (Geerbt von ScriptNameObjectBase.) |
|
GetTextHeader | Returns the text header. (Geerbt von ScriptNameObjectBase.) |
|
GetTextMode | Determines whether the script name is using text mode. (Geerbt von ScriptNameObjectBase.) |
|
GetTextProperty | Gets the text of the object, if not available, throw appropriate exception based on the state of the object. (Geerbt von ScriptNameObjectBase.) |
|
GetType | (Geerbt von Object.) |
|
GetUrnRecursive(StringBuilder) | Assigns an Urn object of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
GetUrnRecursive(StringBuilder, UrnIdOption) | Assigns an Urn object of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
ImplInitialize | Initializes the fields of the SqlSmoObject object. (Geerbt von SqlSmoObject.) |
|
Initialize() | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
|
Initialize(Boolean) | Initializes the object and forces the properties be loaded. (Geerbt von SqlSmoObject.) |
|
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (Geerbt von ScriptNameObjectBase.) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (Geerbt von SqlSmoObject.) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (Geerbt von SqlSmoObject.) |
|
IsVersion80SP3 | Determines whether the version of SQL Server is SQL Server 2000 with SP3. (Geerbt von SqlSmoObject.) |
|
IsVersion90AndAbove | Determines whether the version of SQL Server is SQL Server 2005 or later. (Geerbt von SqlSmoObject.) |
|
MarkDropped | Marks the state of the current object and all of its child collections to be Dropped. (Geerbt von TableViewTableTypeBase.) |
|
MarkForDropImpl | Sets the SqlSmoState for drop operation. (Geerbt von SqlSmoObject.) |
|
MemberwiseClone | (Geerbt von Object.) |
|
PostAlter | The method that is activated after the SqlSmoObject is altered. (Geerbt von SqlSmoObject.) |
|
PostCreate | The method that is activated after the SqlSmoObject is created. (Geerbt von SqlSmoObject.) |
|
PostDrop | The method that is activated after the SqlSmoObject is dropped. (Geerbt von SqlSmoObject.) |
|
ReCompileReferences | Recompiles any view or trigger that depends on the base SMO object. |
|
Refresh | Refreshes the View object or Table object properties. (Überschreibt TableViewTableTypeBase.Refresh().) |
|
RenameImpl | This method supports the SMO infrastructure and is not intended to be used directly from your code. (Geerbt von NamedSmoObject.) |
|
RenameImplWorker | Nur für Informationszwecke identifiziert. Nicht unterstützt. Zukünftige Kompatibilität wird nicht sichergestellt. (Geerbt von NamedSmoObject.) |
|
Script() | Generates a Transact-SQL script that can be used to re-create the database object. (Geerbt von TableViewTableTypeBase.) |
|
Script(ScriptingOptions) | Generates a Transact-SQL script that can be used to re-create the database object with the specified scripting options. (Geerbt von TableViewTableTypeBase.) |
|
ScriptImpl() | Gets a collection of scripts of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
ScriptImpl(ScriptingOptions) | Gets a collection of scripts of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
SetCollectionTextMode | Sets the collection text mode. (Geerbt von ScriptNameObjectBase.) |
|
SetIsSystemNamed | Sets a Boolean value that specifies whether the system is named. (Geerbt von ScriptNameObjectBase.) |
|
SetParentImpl | Sets the parent of the SqlSmoObject to the newParent parameter. (Geerbt von SqlSmoObject.) |
|
SetSchemaOwned | Sets the schema owned value. (Geerbt von NamedSmoObject.) |
|
SetTextBody | Specifies the text body. (Geerbt von ScriptNameObjectBase.) |
|
SetTextHeader | Specifies the text header. (Geerbt von ScriptNameObjectBase.) |
|
SetTextMode | Specifies the text mode. (Geerbt von ScriptNameObjectBase.) |
|
SwitchTextMode | Switches the text mode. (Geerbt von ScriptNameObjectBase.) |
|
ThrowIfTextIsDirtyForAlter | Throws an exception of text has been modified and not persisted. (Geerbt von ScriptNameObjectBase.) |
|
ToString | Returns a String that represents the referenced object. (Geerbt von SqlSmoObject.) |
|
TouchImpl | Not implemented. (Geerbt von SqlSmoObject.) |
|
UnbindDefaultImpl | Unbinds the default columns of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
UnbindRuleImpl | Unbinds rules of the SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
UpdateStatistics() | Updates statistics for the table or view. |
|
UpdateStatistics(StatisticsTarget, StatisticsScanType) | Updates the statistics for the table or view with the option to specify the target and the type of scan performed. |
|
UpdateStatistics(StatisticsTarget, StatisticsScanType, Int32) | Updates the statistics for the table or view with the option to specify the target, the type of scan performed, and the sample size. |
|
UpdateStatistics(StatisticsTarget, StatisticsScanType, Int32, Boolean) | Updates the statistics for the table or view with the option to specify the target, the type of scan performed, the sample size, and whether to recompute the statistics. |
|
Validate | Validates the state of an object. (Geerbt von SmoObjectBase.) |
Zum Anfang
Ereignisse
| Name | Beschreibung | |
|---|---|---|
.gif "Öffentliches Ereignis") |
PropertyChanged | Represents the event that occurs when a property is changed. (Geerbt von SqlSmoObject.) |
|
PropertyMetadataChanged | Represents the event that occurs when property metadata changes. (Geerbt von SqlSmoObject.) |
Zum Anfang
Felder
| Name | Beschreibung | |
|---|---|---|
.gif "Geschütztes Feld") |
m_ExtendedProperties | Represents a property that is defined to extend the properties provided by a SqlSmoObject. (Geerbt von SqlSmoObject.) |
|
singletonParent | Represents the singleton parent. (Geerbt von SqlSmoObject.) |
Zum Anfang
Explizite Schnittstellenimplementierungen
| Name | Beschreibung | |
|---|---|---|
.gif "Explizite Schnittstellenimplementierung") .gif "Private Methode") |
IAlienObject.Discover | Discovers any dependencies. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetDomainRoot | Returns the root of the domain. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetParent | Gets the parent of this object. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetPropertyType | Gets the type of the specified property. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetPropertyValue | Gets the value of the specified property. (Geerbt von SqlSmoObject.) |
|
IAlienObject.GetUrn | Gets the Unified Resource Name (URN) of the object. Verweisen Sie nicht direkt im Code auf dieses Element. Unterstützt die SQL Server-Infrastruktur. (Geerbt von SqlSmoObject.) |
|
IAlienObject.Resolve | Gets the instance that contains the information about the object from the Unified Resource Name (URN) of the object. (Geerbt von SqlSmoObject.) |
|
IAlienObject.SetObjectState | Sets the object state to the specified SfcObjectState value. (Geerbt von SqlSmoObject.) |
|
IAlienObject.SetPropertyValue | Sets the property value. (Geerbt von SqlSmoObject.) |
|
ISfcPropertyProvider.GetPropertySet | Gets the interface reference to the set of properties of this object. (Geerbt von SqlSmoObject.) |
Zum Anfang
Hinweise
The Table and View classes are derived from the TableViewBase class. The Table object represents a SQL Server table and the View object represents a SQL Server view.
Thread Safety
Alle öffentlichen, statischen Elemente dieses Typs (Shared in Microsoft Visual Basic) sind für Vorgänge mit mehreren Threads sicher. Bei Instanzmembern ist die Threadsicherheit nicht gewährleistet.
Beispiele
Arbeiten mit Datenbankobjekten
Threadsicherheit
Alle öffentlichen static (Shared in Visual Basic)-Elemente dieses Typs sind Threadsicher. Für Instanzelemente wird die Threadsicherheit nicht gewährleistet.
Siehe auch
Verweis
Microsoft.SqlServer.Management.Smo-Namespace