.png)
Table Properties
SQL Server 2008 R2
The Table type exposes the following members.
| Name | Description | |
|---|---|---|
|
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. |
|
|
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (Inherited from SqlSmoObject.) |
|
|
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 in which 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 | Gets a value indicating whether the table uses compressed partitions |
|
|
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 the specified index of collection in the table. (Overrides TableViewTableTypeBase.Indexes.) |
|
|
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. |
|
|
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.) |
|
|
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 a String value that specifies the name of the view table type. (Inherited from 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. (Inherited from SqlSmoObject.) |
|
|
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 name of 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. |
|
|
ScalarResult | Gets the scalar result for the referenced object. (Inherited from SqlSmoObject.) |
|
|
Schema | Gets or sets a String value that specifies the name of the schema that contains the view table type. (Inherited from TableViewTableTypeBase.) |
|
|
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.) |
| Name | Description | |
|---|---|---|
|
ISfcSupportsDesignMode.IsDesignMode | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. Gets a Boolean value that indicates whether the object supports design mode. |
