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
.