Table Object
この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。
The Table object exposes the attributes of a single Microsoft SQL Server table.
.gif "現在のオブジェクトを表す SQL-DMO オブジェクト モデル")
Properties
Methods
|
説明
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 Nameproperty is unique for tables with a specific owner within a specific database.
.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. |