Editing SQL statement

This section shows how to edit SQL statements for ODBC connections:

  • ODBC connections: Right-click a table and select Edit SQL to open the SQL Query Tool. In the SQL Statement section, the SQL statement of the table is displayed. You can edit the SQL statement. To see a preview of the table, click Test.
Note: You must not use these key words: create, alter, drop, delete, update, insert, execute, into, checkpoint, dbcc, declare, deny, backup, dump, exec, go, goto, grant, kill, load, restore, revoke, rollback, setuser, transaction, shutdown, use, waitfor, truncate.