Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Table Properties

 

Applies To: SQL Server 2016 Preview

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

NameDescription
System_CAPS_pubpropertyAnsiNullsStatus

Gets the Boolean property value that specifies whether ISO NULL handling is enabled on the table.

System_CAPS_pubpropertyChangeTrackingEnabled

Gets or sets a value that indicates whether change tracking is enabled for the table.

System_CAPS_pubpropertyChecks

Represents a collection of Check objects. Each Check object represents a check constraint defined on the table.

System_CAPS_pubpropertyColumns

Gets a column collection.(Inherited from TableViewTableTypeBase.)

System_CAPS_pubpropertyCreateDate

Gets the date and time when the table was created.

System_CAPS_pubpropertyDataSpaceUsed

Gets the storage space used by the rows of the referenced table in kilobytes.

System_CAPS_pubpropertyDateLastModified

Gets the date and time when the table was last modified.

System_CAPS_pubpropertyDistributionName

Gets or sets the name of the distribution scheme defined by the federation.

System_CAPS_pubpropertyDistributionPolicy

Gets the distribution policy of the table.

System_CAPS_pubpropertyDistributionSkewIndex

Gets the distribution skew index of the table.

System_CAPS_pubpropertyDurability

Gets or sets the value that specifies whether the data stored in the table is recoverable.

System_CAPS_pubpropertyEvents

Gets the events that are associated with the table.

System_CAPS_pubpropertyExtendedProperties

Gets an extended property collection.(Inherited from TableViewTableTypeBase.)

System_CAPS_pubpropertyFakeSystemTable

Gets the Boolean value that specifies whether the table references a system table.

System_CAPS_pubpropertyFederationColumnID

Gets the ID of the column for the federation key.

System_CAPS_pubpropertyFederationColumnName

Gets or sets the name of the column for the federation key.

System_CAPS_pubpropertyFileGroup

Gets or sets the filegroup in which the table is stored.

System_CAPS_pubpropertyFileStreamFileGroup

Gets or sets the filegroup for FILESTREAM data.

System_CAPS_pubpropertyFileStreamPartitionScheme

Gets or sets the partition scheme for FILESTREAM data.

System_CAPS_pubpropertyFileTableDirectoryName

Gets or sets the directory name of the FileTable.

System_CAPS_pubpropertyFileTableNameColumnCollation

Gets the column collation of the FileTable name.

System_CAPS_pubpropertyFileTableNamespaceEnabled

Gets or sets a value that indicates whether the FileTable namespace is enabled.

System_CAPS_pubpropertyForeignKeys

Represents a collection of ForeignKey objects. Each ForeignKey object represents a foreign key defined on the table.

System_CAPS_pubpropertyFullTextIndex

Gets the full text index on the table or view.(Inherited from TableViewBase.)

System_CAPS_pubpropertyHasAfterTrigger

Gets the Boolean property value that specifies whether the table has any after triggers.

System_CAPS_pubpropertyHasClusteredColumnStoreIndex

Gets the Boolean property value that specifies whether the table has a clustered column store index.

System_CAPS_pubpropertyHasClusteredIndex

Gets the Boolean property value that specifies whether the table has a clustered index.

System_CAPS_pubpropertyHasCompressedPartitions

Gets a value indicating whether the table uses compressed partitions.

System_CAPS_pubpropertyHasDeleteTrigger

Gets the Boolean property value that specifies whether the table has a delete trigger.

System_CAPS_pubpropertyHasIndex

Gets the Boolean property value that specifies whether the table has at least one index.

System_CAPS_pubpropertyHasInsertTrigger

Gets the Boolean property value that specifies whether the table has an insert trigger.

System_CAPS_pubpropertyHasInsteadOfTrigger

Gets the Boolean property value that specifies whether the table has any instead of triggers.

System_CAPS_pubpropertyHasUpdateTrigger

Gets the Boolean property value that specifies whether the table has an update trigger.

System_CAPS_pubpropertyID

Gets the ID value that uniquely identifies the table.

System_CAPS_pubpropertyIndexes

Gets the specified index of collection in the table.(Overrides TableViewTableTypeBase.Indexes.)

System_CAPS_pubpropertyIndexSpaceUsed

Gets the space used by the index, in KB.

System_CAPS_pubpropertyIsFileTable

Gets a value that indicates whether a table is FileTable.

System_CAPS_pubpropertyIsIndexable

Gets the Boolean property value that specifies whether an index can be placed on the table.

System_CAPS_pubpropertyIsMemoryOptimized

Gets or sets the Boolean property value that specifies whether the table is memory optimized.

System_CAPS_pubpropertyIsPartitioned

Gets the Boolean property value that specifies whether the table is partitioned.

System_CAPS_pubpropertyIsSchemaOwned

Gets the Boolean property value that specifies whether the table schema is owned.

System_CAPS_pubpropertyIsSystemObject

Gets the Boolean property value that specifies whether the table is a system object.

System_CAPS_pubpropertyIsVarDecimalStorageFormatEnabled

Gets or sets a value that indicates whether var decimal storage is enabled.

System_CAPS_pubpropertyLockEscalation

Gets or sets the type of lock escalation that is used on the table.

System_CAPS_pubpropertyLowPriorityAbortAfterWait

Specifies the action to take after the Low Priority expires during an online index build/switch partition operation on this table.

System_CAPS_pubpropertyLowPriorityMaxDuration

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.

System_CAPS_pubpropertyMaximumDegreeOfParallelism

Gets or sets the maximum number of processors to use in a parallel plan execution that includes the table.

System_CAPS_pubpropertyName

Gets or sets a String value that specifies the name of the view table type.(Inherited from TableViewTableTypeBase.)

System_CAPS_pubpropertyOnlineHeapOperation

Gets or sets the Boolean value that determines whether the table supports online heap or index operations.

System_CAPS_pubpropertyOwner

Gets or sets the owner of the table.

System_CAPS_pubpropertyParent

Gets the Database object that is the parent of the Table object.

System_CAPS_pubpropertyPartitionScheme

Gets or sets the name of the partition scheme that is configured for the table.

System_CAPS_pubpropertyPartitionSchemeParameters

Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a partition scheme parameter defined on the table.

System_CAPS_pubpropertyPhysicalPartitions

Gets the physical partitions in which the table data is stored.

System_CAPS_pubpropertyProperties

Gets a collection of Property objects that represent the object properties.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyQuotedIdentifierStatus

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.

System_CAPS_pubpropertyReplicated

Gets the Boolean property that specifies whether the table is replicated.

System_CAPS_pubpropertyRowCount

Gets the number of rows in the table.

System_CAPS_pubpropertyRowCountAsDouble

Gets the number of rows in the table as a floating point value.

System_CAPS_pubpropertySchema

Gets or sets a String value that specifies the name of the schema that contains the view table type.(Inherited from TableViewTableTypeBase.)

System_CAPS_pubpropertyState

Gets the state of the referenced object.(Inherited from SmoObjectBase.)

System_CAPS_pubpropertyStatistics

Represents a collection of Statistic objects. Each Statistic object represents a statistic counter that is defined on the table or view.(Inherited from TableViewBase.)

System_CAPS_pubpropertyTextFileGroup

Gets or sets the filegroup that is used to maintain long, variable-length data stored in the table.

System_CAPS_pubpropertyTrackColumnsUpdatedEnabled

Gets or sets a value that indicates whether the Database Engine track columns update is enabled.

System_CAPS_pubpropertyTriggers

Represents a collection of Trigger objects. Each Trigger object represents a trigger that is defined on the table or view.(Inherited from TableViewBase.)

System_CAPS_pubpropertyUrn

Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.(Inherited from SqlSmoObject.)

System_CAPS_pubpropertyUserData

Gets or sets user-defined data associated with the referenced object.(Inherited from SmoObjectBase.)

Return to top
Show:
© 2015 Microsoft