Adding tables
This section shows how to add tables for Data Links and ODBC connections:
- Data Links: To add a table, right-click the node and select . To create the SQL statement that creates the table, click the button in the Add Table dialog, the SQL Query Tool dialog opens. Edit the SQL statement and close the SQL Query Tool dialog. In the Add Table dialog specify the ID of the table in the Code field. Select the table type from the Type drop-down list and specify a description for the table. Click to close the dialog and to save the definition.
- ODBC connections: To add a table, right-click the node and select . Create the SQL statement in the SQL Statement section. Specify the ID of the table in the Name field. Select the table type from the drop-down list Type and specify a description for the table. Click to close the dialog and to save the definition.
Note: Do 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.