This page of the wizard of adding/changing an EDB table serves for viewing and, if necessary, manual modifying text of SQL expression generated by the system as a result of previous steps of the wizard.
SQL statements | Contains a list of SQL statements which will be sent to the data source server to execute actions performing adding/changing the EDB table in accordance with the table's parameters specified at the previous steps of the wizard. Description – verbal description of actions performed by the corresponding statement. Modified – indicates whether the text of the statement was modified by manual editing in the pane SQL expression of this very page of wizard. There is a button in the pane: Reset all – cancels all modifications of the statements' text made in the pane SQL expression and assigns the value No to signs Modified. |
SQL expression | Contains text of the SQL statement selected in the pane SQL statements. If the box Change generated SQL expression is checked then the statement text can be edited manually (the user is supposed to be experienced in SQL language). In this case, the user modifying the statement text takes up responsibility for preservation of integrity of the data and for correctness of its processing. Editing pane contains text of the statement. First part of the statement including its title and a part of parameters is displayed above the pane and can not be changed. The remaining text (additional parameters of the statement) is displayed in the pane and can be changed if the box described above is checked. |
Button Execute | Pushing this button sends SQL statements to the data source server for executing operations of creating or modifying the table. |
Adding EDB table as a base table in data source