Generate SQL Dialog Help

This dialog allows you to generate SQL queries for existing schema objects.

Depending on the source object, there is a maximum of 7 tabs available in this dialog.

Tabs for all objects:

• Create
• Drop
• Rename

Tabs only for tables:

• Select
• Delete Records
• Insert
• Update

On this tab, you can generate a CREATE definition.

Additionally, for tables, it is possible to generate a query to create a TEMPORARY table or RAM-based (Valentina, MySQL) table.

This tab generates SQL to drop the object.

This tab allows you to generate a rename query. A new name must be specified at the top of the tab.

This tab produces the SELECT query.

It contains two separate lists of fields with checkboxes – checked fields from the first one are included in the SELECT list of the query, fields from the second one are used to construct the condition.

Both lists have a search control on the top to filter fields by their names.

Use Parameters option allows you to generate a query with parameter placeholders ready to bind values to them either in code or in the SQL Editor:

On this tab, you can generate a query to delete records from the source table. Optionally, you can check the fields to delete only some of the records. A list of fields can be filtered using the search control on the top.

Like the Select Tab, Use Parameters option allows you to get a query with parameters.

This tab produces the statement to insert a record to the source table. You can specify the fields you need to insert.

Use Parameters option places parameter marks in place of the inserted values.

On this tab, you can generate a query to update the table.

It has two lists of fields. In the first list, you can select the list that are going to be updated. The second list allows you to specify the fields used in the condition to update a subset of records.

Use Parameters option places parameter marks for values of all fields used for filtering.