Editing SQL statement
This section shows how to edit SQL statements for ODBC connections:
- ODBC connections: Right-click a table and select 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 .
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
.