ITable

Assembly: Db;

Description

The ITable interface contains properties and methods of the Table repository object.

Inheritance Hierarchy

ITable

Comments

When a new table is created, to ensure its correct work, determine the following minimum set of properties in the settings:

NOTE. To control uniqueness of DBMS data, it is recommended always to create indexes in the Indexes collection. One of the indexes must be a primary key.

Properties

  Property name Brief description
CaseSensitiveNativeName The CaseSensitiveNativeName property determines physical name of the table in a database taking into account case of symbols.
Checks The Checks property returns table constraints.
Database The Database property determines a database, in which given tables are stored.
External The External property returns whether the table is external.
Fields The Fields property returns an object containing all fields of the table.
ForeignKeys The ForeignKeys property returns a collection of table external keys.
Indexes The Indexes property returns an object containing all indexes of the table.
IsRecreateFL The IsRecreateFL property determines whether to recreate the table external connections.
NativeName The NativeName property determines a physical name of the table in a database.
Triggers The Triggers property returns an object containing all triggers of the table.

Methods

  Method name Brief description
AlterTable The AlterTable method updates the structure of specified table on database server according to structure of current table.
AttachTable The AttachTable method updates information about table structure in a repository, according to table structure on database server.
CreateTable The CreateTable method creates a table on the basis of available metadata.
DropTable The DropTable method removes a table from database on server.
UpdateTable The UpdateTable method updates the structure of table on database server according to structure of current table.

See also:

Db Assembly Interfaces | IDatasetModel | IDatasetInstance