Adding tables

This section shows how to add tables for ODBC connections:

ODBC connections: To add a table, right-click the node and select Add table. 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 OK 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.