Table Members

The Table object represents a Microsoft SQL Server table.

The following tables list the members exposed by the Table type.

Public Constructors

	이름	Description
	Table	Overloaded. Initializes a new instance of the Table class.

위쪽

Protected Fields

	이름	Description
	m_ExtendedProperties	(inherited from SqlSmoObject )

위쪽

Public Properties

(see also Protected Properties )

	이름	Description
	AnsiNullsStatus	Gets the Boolean property value that specifies whether SQL-92 NULL handling is enabled on the table.
	Checks	Represents a collection of Check objects. Each Check object represents a check constraint defined on the table.
	Columns	Represents a collection of Column objects. Each Column object represents a column in the table. (inherited from TableViewBase)
	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 associated with the table.
	ExtendedProperties	Represents a collection of ExtendedProperty objects. Each ExtendedProperty object represents an extended property defined on the table or view. (inherited from TableViewBase)
	FakeSystemTable	Gets the Boolean value that specifies whether the table is references a system table.
	FileGroup	Gets or sets the filegroup where the table is stored.
	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.
	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	Represents a collection of Index objects. Each Index object represents an index defined on the table or view. (inherited from TableViewBase)
	IndexSpaceUsed	Gets the space used by the index, in kilobytes.
	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.
	IsSystemObject	Gets the Boolean property value that specifies whether the table is a system object.
	Name	Gets or sets the name of the object. (inherited from NamedSmoObject)
	Parent	Gets the Database object that is the parent of the Table object.
	PartitionScheme	Gets or sets the partition scheme configured for the table.
	PartitionSchemeParameters	Represents a collection of PartitionSchemeParameter objects. Each PartitionSchemeParameter object represents a partition scheme parameter defined on the table.
	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.
	Schema	Gets or sets the schema. (inherited from ScriptSchemaObjectBase)
	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 defined on the table or view. (inherited from TableViewBase)
	TextFileGroup	Gets or sets the filegroup used to maintain long, variable-length data stored in the table.
	Triggers	Represents a collection of Trigger objects. Each Trigger object represents a trigger 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)

위쪽

Protected Properties

	이름	Description
	ExecuteForScalar	Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject)
	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)
	PresetProperties	Gets or sets the preset properties of the referenced object. (inherited from SqlSmoObject)
	ScalarResult	Gets the scalar result for the referenced object. (inherited from SqlSmoObject)

위쪽

Public Methods

(see also Protected Methods )

	이름	Description
	Alter	Updates any Table object property changes on the instance of Microsoft SQL Server.
	AlterWithNoCheck	Updates any Table object property changes on the instance of Microsoft SQL Server without checking the property values first.
	ChangeSchema	Changes the schema on the referenced table.
	CheckIdentityValue	Verifies the integrity of all identity columns in the referenced table.
	CheckTable	Tests the integrity of database pages for the table and indexes defined on the table.
	CheckTableDataOnly	Tests the integrity of database pages for the table data defined on the table.
	Create	Creates a table on the instance of Microsoft SQL Server as defined by the Table object.
	Deny	Overloaded. Denies the specified set of permissions for the specified grantees on the table.
	DisableAllIndexes	Disables all the indexes on the table.
	Drop	Removes the table from the database.
	EnableAllIndexes	Enables all indexes.
	EnumColumnPermissions	Overloaded. Enumerates a list of column permissions for the table.
	EnumForeignKeys	Enumerates a list of foreign keys defined on the table.
	EnumFragmentation	Overloaded. Enumerates information about fragments of data stored in a table or view. (inherited from TableViewBase)
	EnumLastStatisticsUpdates	Overloaded. Enumerates a list of information about the most recent statistics updates.
	EnumObjectPermissions	Overloaded. Enumerates a list of object permissions for the table.
	Equals	Overloaded. (inherited from Object )
	GetHashCode	(inherited from Object )
	GetType	(inherited from Object )
	Grant	Overloaded. Grants the specified set of permissions to the specified grantees on the table.
	Initialize	Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject)
	RebuildIndexes	Rebuilds the indexes on the table.
	RecalculateSpaceUsage	Recalculates the space used on the table.
	ReCompileReferences	Recompiles references on the table.
	ReferenceEquals	(inherited from Object )
	Refresh	Refreshes the View object or Table object properties. (inherited from TableViewBase)
	Rename	Renames the table.
	Revoke	Overloaded. Revokes a previously granted set of permissions from a grantee or grantees on the table.
	Script	Overloaded. Generates a Transact-SQL script that can be used to re-create the table. (inherited from TableViewBase)
	SwitchPartition	Overloaded. Switches the partition of the table.
	ToString	Returns a String that represents the referenced object. (inherited from SqlSmoObject)
	TruncateData	Truncates the data in the table.
	UpdateStatistics	Overloaded. Updates statistics for the table or view. (inherited from TableViewBase)

위쪽

Protected Methods

	이름	Description
	AlterImpl	(inherited from SqlSmoObject )
	AlterImplFinish	(inherited from SqlSmoObject )
	AlterImplInit	(inherited from SqlSmoObject )
	AlterImplWorker	(inherited from SqlSmoObject )
	AppendCommaText	(inherited from ScriptNameObjectBase )
	AppendWithCommaText	(inherited from ScriptNameObjectBase )
	AppendWithOption	(inherited from ScriptNameObjectBase )
	BindDefaultImpl	(inherited from SqlSmoObject )
	BindRuleImpl	(inherited from SqlSmoObject )
	CheckCollation	(inherited from SqlSmoObject )
	CheckObjectState	Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject)
	CheckObjectStateImpl	(inherited from SqlSmoObject )
	CheckTextCorectness	(inherited from ScriptNameObjectBase )
	CheckTextModeSupport	(inherited from ScriptNameObjectBase )
	CheckVersion80	Checks the validity of the object on Microsoft SQL Server 2000. (inherited from SqlSmoObject)
	CheckVersion80SP3	Checks the validity of the object on Microsoft SQL Server 2000 SP3. (inherited from SqlSmoObject)
	CheckVersion90	Check the validity of the object on Microsoft SQL Server 2005. (inherited from SqlSmoObject)
	CheckVersionBelow90	(inherited from SqlSmoObject )
	CleanObject	Cleans the referenced object. (inherited from ScriptNameObjectBase)
	CreateImpl	(inherited from SqlSmoObject )
	CreateImplFinish	(inherited from SqlSmoObject )
	CreateImplInit	(inherited from SqlSmoObject )
	DropImpl	(inherited from SqlSmoObject )
	DropImplWorker	(inherited from SqlSmoObject )
	Finalize	(inherited from Object )
	ForceTextModeOnTextBody	Enforces text mode on the text body. (inherited from ScriptNameObjectBase)
	FormatSqlVariant	(inherited from SqlSmoObject )
	GenerateDataSpaceScript	(inherited from SqlSmoObject )
	GetBindDefaultScript	(inherited from SqlSmoObject )
	GetBindRuleScript	(inherited from SqlSmoObject )
	GetBoolParameter	Overloaded. (inherited from SqlSmoObject )
	GetBraketNameForText	(inherited from ScriptNameObjectBase )
	GetDateTimeParameter	(inherited from SqlSmoObject )
	GetDateTimeParameterAsInt	(inherited from SqlSmoObject )
	GetDBName	Gets the database name associated with the object. (inherited from SqlSmoObject)
	GetEnumParameter	(inherited from SqlSmoObject )
	GetFragOptionString	(inherited from SqlSmoObject )
	GetGuidParameter	(inherited from SqlSmoObject )
	GetIsTextDirty	Determines whether the text value is consistent with stored value. (inherited from ScriptNameObjectBase)
	GetParameter	Overloaded. (inherited from SqlSmoObject )
	GetPropValue	(inherited from SqlSmoObject )
	GetPropValueOptional	(inherited from SqlSmoObject )
	GetPropValueOptionalAllowNull	(inherited from SqlSmoObject )
	GetRealValue	(inherited from SqlSmoObject )
	GetScriptIncludeExists	(inherited from ScriptNameObjectBase )
	GetScriptingOptionsForCreate	(inherited from SqlSmoObject )
	GetServerName	Gets the name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
	GetSqlServerVersionName	Gets the version name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject)
	GetStringParameter	Overloaded. (inherited from SqlSmoObject )
	GetTextBody	Overloaded. Returns the text body. (inherited from ScriptNameObjectBase)
	GetTextForScript	(inherited from ScriptNameObjectBase )
	GetTextHeader	(inherited from ScriptNameObjectBase )
	GetTextMode	Determines whether the script name is using text mode. (inherited from ScriptNameObjectBase)
	GetTextProperty	(inherited from ScriptNameObjectBase )
	GetTimeSpanParameterAsInt	(inherited from SqlSmoObject )
	GetUrnRecursive	Overloaded. (inherited from SqlSmoObject )
	ImplInitialize	(inherited from SqlSmoObject )
	IsCollectionDirty	(inherited from SqlSmoObject )
	IsObjectDirty	Determines whether the referenced object is consistent with the stored object. (inherited from ScriptNameObjectBase)
	IsObjectInitialized	Verifies whether the object has been initialized. (inherited from SqlSmoObject)
	IsObjectInSpace	Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server. (inherited from SqlSmoObject)
	IsVersion80SP3	(inherited from SqlSmoObject )
	MarkDropped	(inherited from TableViewBase )
	MarkForDropImpl	(inherited from SqlSmoObject )
	MemberwiseClone	(inherited from Object )
	PostAlter	(inherited from SqlSmoObject )
	PostCreate	(inherited from SqlSmoObject )
	PostDrop	(inherited from SqlSmoObject )
	RenameImpl	(inherited from NamedSmoObject )
	RenameImplWorker	(inherited from NamedSmoObject )
	ScriptAlter	(inherited from SqlSmoObject )
	ScriptAnsiQI	(inherited from ScriptNameObjectBase )
	ScriptChangeOwner	(inherited from NamedSmoObject )
	ScriptCreate	(inherited from SqlSmoObject )
	ScriptDdl	(inherited from SqlSmoObject )
	ScriptDrop	(inherited from SqlSmoObject )
	ScriptImpl	Overloaded. (inherited from SqlSmoObject )
	ScriptImplWorker	(inherited from SqlSmoObject )
	ScriptInformativeHeaders	(inherited from ScriptNameObjectBase )
	ScriptRename	(inherited from NamedSmoObject )
	SetCollectionTextMode	(inherited from ScriptNameObjectBase )
	SetParentImpl	(inherited from SqlSmoObject )
	SetTextBody	(inherited from ScriptNameObjectBase )
	SetTextHeader	(inherited from ScriptNameObjectBase )
	SetTextMode	(inherited from ScriptNameObjectBase )
	SwitchTextMode	(inherited from ScriptNameObjectBase )
	ThrowIfTextIsDirtyForAlter	(inherited from ScriptNameObjectBase )
	Trace	(inherited from SqlSmoObject )
	UnbindDefaultImpl	(inherited from SqlSmoObject )
	UnbindRuleImpl	(inherited from SqlSmoObject )
	UpdateCollectionState2	(inherited from SqlSmoObject )

위쪽

참고 항목

참조

Table Class
Microsoft.SqlServer.Management.Smo Namespace

관련 자료

Creating, Altering, and Removing Tables
테이블
CREATE TABLE(Transact-SQL)