Assembly: Db;
The ITable interface contains properties and methods of the Table repository object.
ITable
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.
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. |
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: