Export (0) Print
Expand All
Expand Minimize

Table Properties

The Table type exposes the following members.

  Name Description
Public property AnsiNullsStatus Gets the Boolean property value that specifies whether ISO NULL handling is enabled on the table.
Public property ChangeTrackingEnabled Gets or sets a value that indicates whether change tracking is enabled for the table.
Public property Checks Represents a collection of Check objects. Each Check object represents a check constraint defined on the table.
Public property Columns Gets a column collection. (Inherited from TableViewTableTypeBase.)
Public property CreateDate Gets the date and time when the table was created.
Public property DataSpaceUsed Gets the storage space used by the rows of the referenced table in kilobytes.
Public property DateLastModified Gets the date and time when the table was last modified.
Public property DistributionName Gets or sets the name of the distribution scheme defined by the federation.
Public property DistributionPolicy Gets the distribution policy of the table.
Public property DistributionSkewIndex Gets the distribution skew index of the table.
Public property Durability Gets or sets the value that specifies whether the data stored in the table is recoverable.
Public property Events Gets the events that are associated with the table.
Public property ExtendedProperties Gets an extended property collection. (Inherited from TableViewTableTypeBase.)
Public property FakeSystemTable Gets the Boolean value that specifies whether the table references a system table.
Public property FederationColumnID Gets the ID of the column for the federation key.
Public property FederationColumnName Gets or sets the name of the column for the federation key.
Public property FileGroup Gets or sets the filegroup in which the table is stored.
Public property FileStreamFileGroup Gets or sets the filegroup for FILESTREAM data.
Public property FileStreamPartitionScheme Gets or sets the partition scheme for FILESTREAM data.
Public property FileTableDirectoryName Gets or sets the directory name of the FileTable.
Public property FileTableNameColumnCollation Gets the column collation of the FileTable name.
Public property FileTableNamespaceEnabled Gets or sets a value that indicates whether the FileTable namespace is enabled.
Public property ForeignKeys Represents a collection of ForeignKey objects. Each ForeignKey object represents a foreign key defined on the table.
Public property FullTextIndex Gets the full text index on the table or view. (Inherited from TableViewBase.)
Public property HasAfterTrigger Gets the Boolean property value that specifies whether the table has any after triggers.
Public property HasClusteredColumnStoreIndex Gets the Boolean property value that specifies whether the table has a clustered column store index.
Public property HasClusteredIndex Gets the Boolean property value that specifies whether the table has a clustered index.
Public property HasCompressedPartitions Gets a value indicating whether the table uses compressed partitions.
Public property HasDeleteTrigger Gets the Boolean property value that specifies whether the table has a delete trigger.
Public property HasIndex Gets the Boolean property value that specifies whether the table has at least one index.
Public property HasInsertTrigger Gets the Boolean property value that specifies whether the table has an insert trigger.
Public property HasInsteadOfTrigger Gets the Boolean property value that specifies whether the table has any instead of triggers.
Public property HasUpdateTrigger Gets the Boolean property value that specifies whether the table has an update trigger.
Public property ID Gets the ID value that uniquely identifies the table.
Public property Indexes Gets the specified index of collection in the table. (Overrides TableViewTableTypeBase.Indexes.)
Public property IndexSpaceUsed Gets the space used by the index, in KB.
Public property IsFileTable Gets a value that indicates whether a table is FileTable.
Public property IsIndexable Gets the Boolean property value that specifies whether an index can be placed on the table.
Public property IsMemoryOptimized Gets or sets the Boolean property value that specifies whether the table is memory optimized.
Public property IsPartitioned Gets the Boolean property value that specifies whether the table is partitioned.
Public property IsSchemaOwned Gets the Boolean property value that specifies whether the table schema is owned.
Public property IsSystemObject Gets the Boolean property value that specifies whether the table is a system object.
Public property IsVarDecimalStorageFormatEnabled Gets or sets a value that indicates whether var decimal storage is enabled.
Public property LockEscalation Gets or sets the type of lock escalation that is used on the table.
Public property LowPriorityAbortAfterWait Specifies the action to take after the Low Priority expires during an online index build/switch partition operation on this table.
Public property LowPriorityMaxDuration Specifies the amount of time (in minutes) to wait with Low Priority for acquiring the locks required for online index build/switch partition operations on this table.
Public property MaximumDegreeOfParallelism Gets or sets the maximum number of processors to use in a parallel plan execution that includes the table.
Public property Name Gets or sets a String value that specifies the name of the view table type. (Inherited from TableViewTableTypeBase.)
Public property OnlineHeapOperation Gets or sets the Boolean value that determines whether the table supports online heap or index operations.
Public property Owner Gets or sets the owner of the table.
Public property Parent Gets the Database object that is the parent of the Table object.
Public property PartitionScheme Gets or sets the name of the partition scheme that is configured for the table.
Public property PartitionSchemeParameters Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a partition scheme parameter defined on the table.
Public property PhysicalPartitions Gets the physical partitions in which the table data is stored.
Public property Properties Gets a collection of Property objects that represent the object properties. (Inherited from SqlSmoObject.)
Public property 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.
Public property Replicated Gets the Boolean property that specifies whether the table is replicated.
Public property RowCount Gets the number of rows in the table.
Public property RowCountAsDouble Gets the number of rows in the table as a floating point value.
Public property Schema Gets or sets a String value that specifies the name of the schema that contains the view table type. (Inherited from TableViewTableTypeBase.)
Public property State Gets the state of the referenced object. (Inherited from SmoObjectBase.)
Public property 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.)
Public property TextFileGroup Gets or sets the filegroup that is used to maintain long, variable-length data stored in the table.
Public property TrackColumnsUpdatedEnabled Gets or sets a value that indicates whether the Database Engine track columns update is enabled.
Public property Triggers Represents a collection of Trigger objects. Each Trigger object represents a trigger that is defined on the table or view. (Inherited from TableViewBase.)
Public property Urn Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (Inherited from SqlSmoObject.)
Public property UserData Gets or sets user-defined data associated with the referenced object. (Inherited from SmoObjectBase.)
Top

  Name Description
Explicit interface implemetation Private property 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.
Top

Community Additions

ADD
Show:
© 2014 Microsoft