Table Properties

(see also Protected Properties )
  Nom Description
ms220509.pubproperty(fr-fr,SQL.90).gif AnsiNullsStatus
Gets the Boolean property value that specifies whether SQL-92 NULL handling is enabled on the table.
ms220509.pubproperty(fr-fr,SQL.90).gif Checks
Represents a collection of Check objects. Each Check object represents a check constraint defined on the table.
ms220509.pubproperty(fr-fr,SQL.90).gif Columns 
Represents a collection of Column objects. Each Column object represents a column in the table.
(inherited from TableViewBase )
ms220509.pubproperty(fr-fr,SQL.90).gif CreateDate
Gets the date and time when the table was created.
ms220509.pubproperty(fr-fr,SQL.90).gif DataSpaceUsed
Gets the storage space used by the rows of the referenced table in kilobytes.
ms220509.pubproperty(fr-fr,SQL.90).gif DateLastModified
Gets the date and time when the table was last modified.
ms220509.pubproperty(fr-fr,SQL.90).gif Events
Gets the events associated with the table.
ms220509.pubproperty(fr-fr,SQL.90).gif ExtendedProperties 
Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the table or view.
(inherited from TableViewBase )
ms220509.pubproperty(fr-fr,SQL.90).gif FakeSystemTable
Gets the Boolean value that specifies whether the table is references a system table.
ms220509.pubproperty(fr-fr,SQL.90).gif FileGroup
Gets or sets the filegroup where the table is stored.
ms220509.pubproperty(fr-fr,SQL.90).gif ForeignKeys
Represents a collection of ForeignKey objects. Each ForeignKey object represents a foreign key defined on the table.
ms220509.pubproperty(fr-fr,SQL.90).gif FullTextIndex 
Gets the full text index on the table or view.
(inherited from TableViewBase )
ms220509.pubproperty(fr-fr,SQL.90).gif HasAfterTrigger
Gets the Boolean property value that specifies whether the table has any after triggers.
ms220509.pubproperty(fr-fr,SQL.90).gif HasClusteredIndex
Gets the Boolean property value that specifies whether the table has a clustered index.
ms220509.pubproperty(fr-fr,SQL.90).gif HasDeleteTrigger
Gets the Boolean property value that specifies whether the table has a delete trigger.
ms220509.pubproperty(fr-fr,SQL.90).gif HasIndex
Gets the Boolean property value that specifies whether the table has at least one index.
ms220509.pubproperty(fr-fr,SQL.90).gif HasInsertTrigger
Gets the Boolean property value that specifies whether the table has an insert trigger.
ms220509.pubproperty(fr-fr,SQL.90).gif HasInsteadOfTrigger
Gets the Boolean property value that specifies whether the table has any instead of triggers.
ms220509.pubproperty(fr-fr,SQL.90).gif HasUpdateTrigger
Gets the Boolean property value that specifies whether the table has an update trigger.
ms220509.pubproperty(fr-fr,SQL.90).gif ID
Gets the ID value that uniquely identifies the table.
ms220509.pubproperty(fr-fr,SQL.90).gif Indexes 
Represents a collection of Index objects. Each Index object represents an index defined on the table or view.
(inherited from TableViewBase )
ms220509.pubproperty(fr-fr,SQL.90).gif IndexSpaceUsed
Gets the space used by the index, in kilobytes.
ms220509.pubproperty(fr-fr,SQL.90).gif IsIndexable
Gets the Boolean property value that specifies whether an index can be placed on the table.
ms220509.pubproperty(fr-fr,SQL.90).gif IsPartitioned
Gets the Boolean property value that specifies whether the table is partitioned.
ms220509.pubproperty(fr-fr,SQL.90).gif IsSystemObject
Gets the Boolean property value that specifies whether the table is a system object.
ms220509.pubproperty(fr-fr,SQL.90).gif Name 
Gets or sets the name of the object.
(inherited from NamedSmoObject )
ms220509.pubproperty(fr-fr,SQL.90).gif Parent
Gets the Database object that is the parent of the Table object.
ms220509.pubproperty(fr-fr,SQL.90).gif PartitionScheme
Gets or sets the partition scheme configured for the table.
ms220509.pubproperty(fr-fr,SQL.90).gif PartitionSchemeParameters
Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a partition scheme parameter defined on the table.
ms220509.pubproperty(fr-fr,SQL.90).gif Properties 
Gets a collection of Property objects that represent the object properties.
(inherited from SqlSmoObject )
ms220509.pubproperty(fr-fr,SQL.90).gif 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.
ms220509.pubproperty(fr-fr,SQL.90).gif Replicated
Gets the Boolean property that specifies whether the table is replicated.
ms220509.pubproperty(fr-fr,SQL.90).gif RowCount
Gets the number of rows in the table.
ms220509.pubproperty(fr-fr,SQL.90).gif RowCountAsDouble
Gets the number of rows in the table as a floating point value.
ms220509.pubproperty(fr-fr,SQL.90).gif Schema 
Gets or sets the schema.
(inherited from ScriptSchemaObjectBase )
ms220509.pubproperty(fr-fr,SQL.90).gif State 
Gets the state of the referenced object.
(inherited from SmoObjectBase )
ms220509.pubproperty(fr-fr,SQL.90).gif Statistics 
Represents a collection of Statistic objects. Each Statistic object represents a statistic counter defined on the table or view.
(inherited from TableViewBase )
ms220509.pubproperty(fr-fr,SQL.90).gif TextFileGroup
Gets or sets the filegroup used to maintain long, variable-length data stored in the table.
ms220509.pubproperty(fr-fr,SQL.90).gif Triggers 
Represents a collection of Trigger objects. Each Trigger object represents a trigger defined on the table or view.
(inherited from TableViewBase )
ms220509.pubproperty(fr-fr,SQL.90).gif Urn 
Gets the Uniform Resource Name (URN) address value that uniquely identifies the object.
(inherited from SqlSmoObject )
ms220509.pubproperty(fr-fr,SQL.90).gif UserData 
Gets or sets user-defined data associated with the referenced object.
(inherited from SmoObjectBase )

  Nom Description
ms220509.protproperty(fr-fr,SQL.90).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 )
ms220509.protproperty(fr-fr,SQL.90).gif ObjectInSpace 
Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly.
(inherited from SqlSmoObject )
ms220509.protproperty(fr-fr,SQL.90).gif PresetProperties 
Gets or sets the preset properties of the referenced object.
(inherited from SqlSmoObject )
ms220509.protproperty(fr-fr,SQL.90).gif ScalarResult 
Gets the scalar result for the referenced object.
(inherited from SqlSmoObject )

Ajouts de la communauté

AJOUTER
Afficher: