tools.prompt_defs table
The tools.prompt_defs table is used to store all prompt definitions.
The following table describes the columns in the tools.prompt_defs table.
| Column name | Data type | Description |
|---|---|---|
| Name | varchar(64) | The name of the prompt. |
| Prompt | varchar(64) | The prompt title which appears at the top of the prompt window. |
| Default | varchar(64) | The default value to enter if no value is entered by the user. |
| Value | varchar(255) | The list of available values. |
| Type | integer | The prompt type. Type 7 is a link to a menu definition with the same name as the prompt. |