Writing SQL queries
Schema Compare allows writing and executing SQL statements.
To create a new SQL query click New SQL in the menu ribbon.
The SQL editor will be displayed.
Every SQL document contains the Text view with a built-in SQL editor. You switch to this view to edit your SQL queries.
When you type text in SQL editor, it automatically recognizes and highlights SQL syntax.
For ease of SQL writing and reviewing, you can also use such supported shortcut keys as: CTRL+PLUS (+) KEY (to zoom the query in), CTRL+MINUS (-) KEY (to zoom the query out), and CTRL+0 (to return an SQL document to the one-to-one scale).
You write and execute SQL queries not only by one at a time but you may compose SQL scripts as well. SQL scripts consist of multiple SQL statements separated by the appropriate statement delimiter.