Table Object

后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。

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

显示当前对象的 SQL-DMO 对象模型

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

Grant Method (Table, View)

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)

GenerateSQL Method (Table, UserDefinedDatatype)

 

备注

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 re-create 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. If 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.

ms141894.note(zh-cn,SQL.90).gif注意:
The Table object is compatible with instances of SQL Server versions 7.0 and later. However, the Table2 object extends the functionality of the Table object for use with features that were introduced in SQL Server 2000.

请参阅

参考

Table2 Object

帮助和信息

获取 SQL Server 2005 帮助