To report a found bug,
please, select the text with the bug and click Report a Bug or
CTRL+ENTER.
Help
system 10.4 of 09/07/2024,
©
FORESIGHT
The DalSystemDictionary enumeration contains types of the cursor obtained as a result of SQL query execution to database.
It is used by the following properties and methods:
| Value | Brief description |
| 0 | Tables. The cursor that contains system information about tables stored in the database. |
| 1 | Views. The cursor that contains system information about views stored in the database. |
| 2 | Columns. The cursor that contains system information about table fields stored in the database. |
| 3 | Indexes. The cursor that contains system information about table indexes stored in the database. |
| 4 | Trigers. The cursor that contains system information about table triggers stored in the database. |
| 5 | Procedures. The cursor that contains system information about procedures stored in the database. |
| 6 | FileGroups. The cursor that contains system information about file groups created in the database. |
| 7 | ForeignKeys. The cursor that contains system information about external keys created for tables. |
| 8 | ForeignLinks. The cursor that contains system information about connections created between the tables. |
ForeignKeys. The returned cursor contains the following fields:
TABLE_NAME. Table name.
FK_NAME. External key name.
DELETE_RULE. Deletion method (1 - cascade deletion).
COLUMN_NAME. External key field name.
POSITION. Field position in the external key fields list.
RTABLE_NAME. Table name, for which an external key is created.
RCOLUMN_NAME. External table field name.
See also: