Show contents

Db > Db Assembly Interfaces > ITable

ITable

Assembly: Db;

Namespace: Prognoz.Platform.Interop.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:

• Database.

• NativeName.

• Fields.

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