Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSDN Library

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