Table Object

SQL-DMO

Table Object

The Table object exposes the attributes of a single Microsoft® SQL Server™ table.

Properties

Attributes Property	HasIndex Property
CreateDate Property	ID Property
DataSpaceUsed Property	InAlter Property
FakeSystemTable Property	IndexSpaceUsed Property
FileGroup Property	Name Property
FullTextCatalogName Property	Owner Property (Database Objects)
FullTextIndex Property	Rows Property
FullTextIndexActive Property	SystemObject Property
FullTextKeyColumn Property	TextFileGroup Property
HasClusteredIndex Property	UniqueIndexForFullText Property

Methods

BeginAlter Method	GenerateSQL Method (Table, UserDefinedDatatype)
CancelAlter Method	ImportData Method
CheckIdentityValue Method	InsertColumn Method
CheckTable Method	ListAvailableUniqueIndexesForFullText Method
CheckTableDataOnly Method	ListPermissions Method
Deny Method (Table, View)	ListUserPermissions Method
DoAlter Method	RebuildIndexes Method
DoAlterWithNoCheck Method	RecalcSpaceUsage Method
EnumDependencies Method	ReCompileReferences Method
EnumLastStatisticsUpdates Method	Refresh Method
EnumReferencedKeys Method	Remove Method (Objects)
EnumReferencedTables Method	Revoke Method (Table, View)
EnumReferencingKeys Method	Script Method (Table Object)
EnumReferencingTables Method	TruncateData Method
ExportData Method	UpdateStatistics Method
FullTextIndexScript Method	UpdateStatisticsWith Method (Table)
Grant Method (Table, View)

Remarks

SQL Server Table objects contain columns that define a table, and row data that populate it. Table columns can maintain declarative referential integrity constraints, such as PRIMARY KEY and FOREIGN KEY. Indexes defined on table columns can enforce a UNIQUE constraint or can provide optimized row access. Tables participate in SQL Server user-based security.

With the Table object, you can:

Create a SQL Server table.
Change an existing SQL Server table by adding or dropping columns.
Export data from, or import data to, an existing SQL Server table.
Establish optimal data-access paths by adding, dropping, and rebuilding table indexes.
Enforce business rules by adding or modifying table triggers executed when data is added or updated within the table.
Generate a Transact-SQL script to recreate an existing SQL Server table.
Remove a table from a SQL Server database.

The Name property of a Table object uses the SQL Server data type sysname. When a server running SQL Server uses quoted identifiers, the Name property string can contain spaces. The value of the Name property is unique for tables with a specific owner within a specific database.

Note The Table object is compatible with instances of SQL Server 2000 and SQL Server version 7.0. However, the Table2 object extends the functionality of the Table object for use with features that are new in SQL Server 2000.

Table Object

Properties

Methods

Remarks

See Also