Editing SQL statement
This section shows how to edit SQL statements for Data Links and ODBC connections:
- Data Links: Right-click a table and select to open the SQL Query Tool.
- 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.
Related topics