Viewing Generated SQL Statements

The SQL page of the Table Editor document displays SQL statements generated as a result of the user's actions on other Table Editor pages. The generated SQL includes CREATE TABLE, ALTER TABLE, DROP INDEX, and CREATE INDEX statements.

Generated CREATE TABLE SQL can be saved in the text file using the File->Save menu option.

The SQL page also allows generating templates for SELECT, INSERT and UPDATE statements for a table. You can copy and paste these templates into the SQL Editor window. To switch among CREATE TABLE, ALTER TABLE or templates SQL, use buttons located at the top of the SQL page.

You can use the Send to SQL Editor popup menu to open a generated SQL statement for editing in new SQL Editor document.