Database Reference
In-Depth Information
Finally, you'll create a function that, when passed a status name such as
OPEN
,
passes back the ID for that status. This function is used in a number of places, because
you can't guarantee you know the ID value of a given status. Therefore, this function is
the only safe way to get the associated ID for a given status.
When you're in any of the SQL Workshop tools, an icon menu in the upper-right
corner of the screen provides quick links to each of the other tools. In
Figure 4-19
, the
hand-shaped pointer is pointing to the SQL Scripts icon.
Figure 4-19.
The icon-based quick menu in SQL Workshop
Here's what to do to run the script that will update your schema objects appropri-
ately:
1.
Click the
SQL Scripts
icon in the SQL Workshop's quick menu. If you're
not already in SQL Workshop, use the pull-down menu from the SQL
Workshop tab and choose
SQL Scripts
.
2.
Click the
Upload
button in the upper-right section of the screen.
3.
Click
Browse
to search for the SQL file to upload.
4.
In the pop-up file-finder window, locate and select the
ch4_schema_changes.sql
file, and click
Upload
. You don't need to
give the script a name; it defaults to the name of the script as it appears at
the OS level.
Once the file has been uploaded, you're presented with a SQL Scripts
report showing the script that you just uploaded. From this point, you can
either edit or run the script. If you want to see what the script contains, feel
free to edit it. You can run the script from the edit screen as well.
5.
Run the script by clicking either the
Run
button (if you're editing the script)
or the
Run
icon (if you're still viewing the SQL Scripts report).
6.
As shown in
Figure 4-20
, you're asked to make a selection between Run in
Background and Run Now. Select
Run Now
.
