Download User`s Guide

SQL Data Manager
10 Click Tools
click
Query Run Current SQL Statement in Text or
.
The Text Results tab contains the following result:
SQL statement (script) has executed successfully.
1 row(s) were affected.
Now look at the data in the “Room” table again to verify that you
deleted the record.
11 Set Query Builder to build a SELECT statement (change the
query type to “Select.”)
12 Click the column * (All columns) then run the SQL statement
for output to the Grid Results tab.
13 Scroll the results grid until you see the records for the Boerner
Building.
Notice that room 100 is no longer listed as one of the classrooms
for the Boerner Building.
³ To add a table to Query Builder Diagram
This task requires that Query Builder Diagram be active (showing).
1
Perform one of the following actions:
.
a. Click Tools Query Builder Add Table or click
b. Right-click in the pane of Query Builder Diagram, then
click Add table.
A list appears that shows the tables in the active database.
2
Click the desired table in the list.
3
Click Add.
See also “Behavior When Query Builder Diagram Contains No
Tables” on page 6-12.
6-86