Table Members
The Table object represents a SQL Server table.
The following tables list the members exposed by the Table type.
Public Constructors
| Name | Description | |
|---|---|---|
| Table | Overloaded. Initializes a new instance of the Table class. |
Top
.gif "ms220496.protfield(pl-pl,SQL.100).gif")
Public Properties
(see also Protected Properties )
| Name | Description | |
|---|---|---|
.gif "ms220496.pubproperty(pl-pl,SQL.100).gif") |
AnsiNullsStatus | Gets the Boolean property value that specifies whether ISO NULL handling is enabled on the table. |
|
ChangeTrackingEnabled | Specifies if change tracking is enabled for the table. |
|
Checks | Represents a collection of Check objects. Each Check object represents a check constraint defined on the table. |
|
Columns | Gets a column collection. (inherited from TableViewTableTypeBase) |
|
CreateDate | Gets the date and time when the table was created. |
|
DataSpaceUsed | Gets the storage space used by the rows of the referenced table in kilobytes. |
|
DateLastModified | Gets the date and time when the table was last modified. |
|
Events | Gets the events that are associated with the table. |
|
ExtendedProperties | Gets an extended property collection. (inherited from TableViewTableTypeBase) |
|
FakeSystemTable | Gets the Boolean value that specifies whether the table references a system table. |
|
FileGroup | Gets or sets the filegroup where the table is stored. |
|
FileStreamFileGroup | Gets or sets the filegroup for FILESTREAM data. |
|
FileStreamPartitionScheme | Gets or sets the partition scheme for FILESTREAM data. |
|
ForeignKeys | Represents a collection of ForeignKey objects. Each ForeignKey object represents a foreign key defined on the table. |
|
FullTextIndex | Gets the full text index on the table or view. (inherited from TableViewBase) |
|
HasAfterTrigger | Gets the Boolean property value that specifies whether the table has any after triggers. |
|
HasClusteredIndex | Gets the Boolean property value that specifies whether the table has a clustered index. |
|
HasCompressedPartitions | |
|
HasDeleteTrigger | Gets the Boolean property value that specifies whether the table has a delete trigger. |
|
HasIndex | Gets the Boolean property value that specifies whether the table has at least one index. |
|
HasInsertTrigger | Gets the Boolean property value that specifies whether the table has an insert trigger. |
|
HasInsteadOfTrigger | Gets the Boolean property value that specifies whether the table has any instead of triggers. |
|
HasUpdateTrigger | Gets the Boolean property value that specifies whether the table has an update trigger. |
|
ID | Gets the ID value that uniquely identifies the table. |
|
Indexes | Gets an index collection. (inherited from TableViewTableTypeBase) |
|
IndexSpaceUsed | Gets the space used by the index, in KB. |
|
IsIndexable | Gets the Boolean property value that specifies whether an index can be placed on the table. |
|
IsPartitioned | Gets the Boolean property value that specifies whether the table is partitioned. |
|
IsSchemaOwned | Gets the Boolean property value that specifies whether the table schema is owned. |
|
IsSystemObject | Gets the Boolean property value that specifies whether the table is a system object. |
|
IsVarDecimalStorageFormatEnabled | Specifies if var decimal storage is enabled. |
|
LockEscalation | Gets or sets the type of lock escalation that is used on the table. |
|
MaximumDegreeOfParallelism | Gets or sets the maximum number of processors to use in a parallel plan execution that includes the table. |
|
Name | Gets or sets the name of the Schema Object Base. (inherited from ScriptSchemaObjectBase) |
|
OnlineHeapOperation | Gets or sets the Boolean value that determines whether the table supports online heap or index operations. |
|
Owner | Gets or sets the owner of the table. |
|
Parent | Gets the Database object that is the parent of the Table object. |
|
PartitionScheme | Gets or sets the partition scheme that is configured for the table. |
|
PartitionSchemeParameters | Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a partition scheme parameter defined on the table. |
|
PhysicalPartitions | Gets the physical partitions in which the table data is stored. |
|
Properties | Gets a collection of Property objects that represent the object properties. (inherited from SqlSmoObject) |
|
QuotedIdentifierStatus | Gets or sets a Boolean property value that specifies 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 property that specifies whether the table is replicated. |
|
RowCount | Gets the number of rows in the table. |
|
RowCountAsDouble | Gets the number of rows in the table as a floating point value. |
|
Schema | Gets or sets the schema. (inherited from ScriptSchemaObjectBase) |
|
State | Gets the state of the referenced object. (inherited from SmoObjectBase) |
|
Statistics | Represents a collection of Statistic objects. Each Statistic object represents a statistic counter that is defined on the table or view. (inherited from TableViewBase) |
|
TextFileGroup | Gets or sets the filegroup that is used to maintain long, variable-length data stored in the table. |
|
TrackColumnsUpdatedEnabled | Indicates whether the Database Engine tracks which columns were updated |
|
Triggers | Represents a collection of Trigger objects. Each Trigger object represents a trigger that is defined on the table or view. (inherited from TableViewBase) |
|
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (inherited from SqlSmoObject) |
|
UserData | Gets or sets user-defined data associated with the referenced object. (inherited from SmoObjectBase) |
Top
Protected Properties
| Name | Description | |
|---|---|---|
.gif "ms220496.protproperty(pl-pl,SQL.100).gif") |
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject) |
|
IsTouched | Gets the Boolean property value that specifies whether the object properties have been updated but not yet persisted on the server. (inherited from SqlSmoObject) |
|
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. (inherited from SqlSmoObject) |
|
ScalarResult | Gets the scalar result for the referenced object. (inherited from SqlSmoObject) |
Top
Public Methods
(see also Protected Methods )
| Name | Description | |
|---|---|---|
.gif "ms220496.pubmethod(pl-pl,SQL.100).gif") |
Alter | Updates any Table object property changes on the instance of SQL Server. |
|
AlterWithNoCheck | Updates any Table object property changes on the instance of SQL Server without checking the property values first. |
|
ChangeSchema | Changes the schema on the referenced table. |
|
CheckIdentityValue | Verifies the integrity of all identity columns in the referenced table. |
|
CheckTable | Tests the integrity of database pages for the table and indexes defined on the table. |
|
CheckTableDataOnly | Tests the integrity of database pages for the table data defined on the table. |
|
Create | Creates a table on the instance of SQL Server as defined by the Table object. |
|
Deny | Overloaded. Denies the specified set of permissions for the specified grantees on the table. |
|
DisableAllIndexes | Disables all the indexes that are on the table. |
|
Discover | (inherited from SqlSmoObject ) |
|
Drop | Removes the table from the database. |
|
EnableAllIndexes | Enables all indexes. |
|
EnumColumnPermissions | Overloaded. |
|
EnumForeignKeys | Enumerates a list of primary keys in which the table is referenced as a foreign key. |
|
EnumFragmentation | Overloaded. Enumerates information about fragments of data that are stored in a table or view. (inherited from TableViewBase) |
|
EnumLastStatisticsUpdates | Overloaded. Enumerates a list of information about the most recent statistics updates. |
|
EnumObjectPermissions | Overloaded. Enumerates a list of object permissions for the table. |
|
EnumScript | Overloaded. Returns an enumerable object. |
|
Equals | Overloaded. (inherited from Object ) |
.gif "ms220496.static(pl-pl,SQL.100).gif") |
GetChildType | (inherited from SqlSmoObject ) |
|
GetHashCode | (inherited from Object ) |
|
GetType | (inherited from Object ) |
|
GetTypeFromUrnSkeleton | (inherited from SqlSmoObject ) |
|
Grant | Overloaded. Grants the specified set of permissions to the specified grantees on the table. |
|
Initialize | Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject) |
|
Rebuild | Overloaded. |
|
RebuildIndexes | Rebuilds the indexes on the table. |
|
RecalculateSpaceUsage | Recalculates the space that is used on the table. |
|
ReCompileReferences | Recompiles references that are on the table. (inherited from TableViewBase) |
|
ReferenceEquals | (inherited from Object ) |
|
Refresh | Refreshes the View object or Table object properties. (inherited from TableViewBase) |
|
Rename | Renames the table. |
|
Revoke | Overloaded. Revokes a previously granted set of permissions from a grantee or grantees on the table. |
|
Script | Overloaded. Generates a Transact-SQL script that can be used to re-create the database object. (inherited from TableViewTableTypeBase) |
|
SwitchPartition | Overloaded. Switches the partition of the table. |
|
ToString | Returns a String that represents the referenced object. (inherited from SqlSmoObject) |
|
TruncateData | Truncates the data in the table. |
|
UpdateStatistics | Overloaded. Updates statistics for the table or view. (inherited from TableViewBase) |
|
Validate | (inherited from SmoObjectBase ) |
Top
Protected Methods
| Name | Description | |
|---|---|---|
.gif "ms220496.protmethod(pl-pl,SQL.100).gif") |
AddDatabaseContext | (inherited from SqlSmoObject ) |
|
AlterImpl | (inherited from SqlSmoObject ) |
|
AlterImplFinish | (inherited from SqlSmoObject ) |
|
AlterImplInit | (inherited from SqlSmoObject ) |
|
AlterImplWorker | (inherited from SqlSmoObject ) |
|
AppendCommaText | (inherited from ScriptNameObjectBase ) |
|
AppendWithCommaText | (inherited from ScriptNameObjectBase ) |
|
AppendWithOption | (inherited from ScriptNameObjectBase ) |
|
BindDefaultImpl | (inherited from SqlSmoObject ) |
|
BindRuleImpl | (inherited from SqlSmoObject ) |
|
CheckCollation | (inherited from SqlSmoObject ) |
|
CheckObjectDirty | (inherited from ScriptNameObjectBase ) |
|
CheckObjectState | Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject) |
|
CheckObjectStateImpl | (inherited from SqlSmoObject ) |
|
CheckTextCorectness | (inherited from ScriptNameObjectBase ) |
|
CheckTextModeSupport | (inherited from ScriptNameObjectBase ) |
|
CheckVersion100 | (inherited from SqlSmoObject ) |
|
CheckVersion80 | Checks the validity of the object on SQL Server 2000. (inherited from SqlSmoObject) |
|
CheckVersion80SP3 | Checks the validity of the object on SQL Server 2000 SP3. (inherited from SqlSmoObject) |
|
CheckVersion90 | Check the validity of the object on SQL Server 2005. (inherited from SqlSmoObject) |
|
CheckVersionBelow90 | (inherited from SqlSmoObject ) |
|
CleanObject | Cleans the referenced object. (inherited from ScriptNameObjectBase) |
|
CreateImpl | (inherited from SqlSmoObject ) |
|
CreateImplFinish | (inherited from SqlSmoObject ) |
|
CreateImplInit | (inherited from SqlSmoObject ) |
|
DropImpl | (inherited from SqlSmoObject ) |
|
DropImplWorker | (inherited from SqlSmoObject ) |
|
EnumScriptImpl | (inherited from SqlSmoObject ) |
|
EnumScriptImplWorker | (inherited from SqlSmoObject ) |
|
Finalize | (inherited from Object ) |
|
ForceTextModeOnTextBody | Enforces text mode on the text body. (inherited from ScriptNameObjectBase) |
|
FormatSqlVariant | (inherited from SqlSmoObject ) |
|
GenerateDataSpaceFileStreamScript | (inherited from SqlSmoObject ) |
|
GenerateDataSpaceScript | (inherited from SqlSmoObject ) |
|
GetBindDefaultScript | (inherited from SqlSmoObject ) |
|
GetBindRuleScript | (inherited from SqlSmoObject ) |
|
GetBoolParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetBraketNameForText | (inherited from ScriptNameObjectBase ) |
|
GetDateTimeParameter | (inherited from SqlSmoObject ) |
|
GetDateTimeParameterAsInt | (inherited from SqlSmoObject ) |
|
GetDBName | Gets the database name that is associated with the object. (inherited from SqlSmoObject) |
|
GetEnumParameter | (inherited from SqlSmoObject ) |
|
GetFragOptionString | (inherited from SqlSmoObject ) |
|
GetGuidParameter | (inherited from SqlSmoObject ) |
|
GetIsTextDirty | Determines whether the text value is consistent with stored value. (inherited from ScriptNameObjectBase) |
|
GetParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetPropValue | (inherited from SqlSmoObject ) |
|
GetPropValueOptional | (inherited from SqlSmoObject ) |
|
GetPropValueOptionalAllowNull | (inherited from SqlSmoObject ) |
|
GetRealValue | (inherited from SqlSmoObject ) |
|
GetScriptIncludeExists | (inherited from ScriptNameObjectBase ) |
|
GetScriptingOptionsForCreate | (inherited from SqlSmoObject ) |
|
GetServerName | Gets the name of the instance of SQL Server with which the object is associated. (inherited from SqlSmoObject) |
|
GetServerObject | (inherited from SqlSmoObject ) |
|
GetSqlServerVersionName | Gets the version name of the instance of SQL Server with which the object is associated. (inherited from SqlSmoObject) |
|
GetStringParameter | Overloaded. (inherited from SqlSmoObject ) |
|
GetTextBody | Overloaded. Returns the text body. (inherited from ScriptNameObjectBase) |
|
GetTextForScript | Overloaded. (inherited from ScriptNameObjectBase ) |
|
GetTextHeader | (inherited from ScriptNameObjectBase ) |
|
GetTextMode | Determines whether the script name is using text mode. (inherited from ScriptNameObjectBase) |
|
GetTextProperty | Overloaded. (inherited from ScriptNameObjectBase ) |
|
GetTimeSpanParameterAsInt | (inherited from SqlSmoObject ) |
|
GetUrnRecursive | Overloaded. (inherited from SqlSmoObject ) |
|
ImplInitialize | (inherited from SqlSmoObject ) |
|
IsCollectionDirty | (inherited from SqlSmoObject ) |
|
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (inherited from ScriptNameObjectBase) |
|
IsObjectInitialized | Verifies whether the object has been initialized. (inherited from SqlSmoObject) |
|
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of SQL Server. (inherited from SqlSmoObject) |
|
IsVersion80SP3 | (inherited from SqlSmoObject ) |
|
MarkDropped | Marks a view table type as drooped. (inherited from TableViewTableTypeBase) |
|
MarkForDropImpl | (inherited from SqlSmoObject ) |
|
MemberwiseClone | (inherited from Object ) |
|
PostAlter | (inherited from SqlSmoObject ) |
|
PostCreate | (inherited from SqlSmoObject ) |
|
PostDrop | (inherited from SqlSmoObject ) |
|
RenameImpl | (inherited from NamedSmoObject ) |
|
RenameImplWorker | (inherited from NamedSmoObject ) |
|
ScriptAlter | (inherited from SqlSmoObject ) |
|
ScriptAnsiQI | (inherited from ScriptNameObjectBase ) |
|
ScriptChangeOwner | (inherited from NamedSmoObject ) |
|
ScriptCreate | (inherited from SqlSmoObject ) |
|
ScriptDdl | (inherited from SqlSmoObject ) |
|
ScriptDrop | (inherited from SqlSmoObject ) |
|
ScriptImpl | Overloaded. (inherited from SqlSmoObject ) |
|
ScriptImplWorker | (inherited from SqlSmoObject ) |
|
ScriptInformativeHeaders | (inherited from ScriptNameObjectBase ) |
|
ScriptRename | (inherited from NamedSmoObject ) |
|
SetCollectionTextMode | (inherited from ScriptNameObjectBase ) |
|
SetParentImpl | (inherited from SqlSmoObject ) |
|
SetTextBody | (inherited from ScriptNameObjectBase ) |
|
SetTextHeader | (inherited from ScriptNameObjectBase ) |
|
SetTextMode | (inherited from ScriptNameObjectBase ) |
|
SwitchTextMode | (inherited from ScriptNameObjectBase ) |
|
ThrowIfTextIsDirtyForAlter | (inherited from ScriptNameObjectBase ) |
|
TouchImpl | (inherited from SqlSmoObject ) |
|
Trace | (inherited from SqlSmoObject ) |
|
UnbindDefaultImpl | (inherited from SqlSmoObject ) |
|
UnbindRuleImpl | (inherited from SqlSmoObject ) |
|
UpdateCollectionState2 | (inherited from SqlSmoObject ) |
Top
Public Events
| Name | Description | |
|---|---|---|
.gif "ms220496.pubevent(pl-pl,SQL.100).gif") |
PropertyChanged | (inherited from SqlSmoObject ) |
|
PropertyMetadataChanged | (inherited from SqlSmoObject ) |
Top
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.Discover | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.GetParent | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.GetProperty | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.GetUrn | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.Resolve | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.IAlienObject.SetProperty | (inherited from SqlSmoObject ) | |
| Microsoft.SqlServer.Management.Sdk.Sfc.ISfcPropertyProvider.GetPropertySet | (inherited from SqlSmoObject ) |
Top