79704
Adding a New Table Constraint
In this example, you add a table constraint to the purchase_orders table that you created in "Example: Creating a Table" on page 8-11. To enforce the rule that the po_ date_received valuc must be either the same day as. or later than. the value of
po_
datę, you add a chcck constraint.
To add a table constraint to the PURCHASE_ORDERS table:
1. Navigatc to the PURCHASE_ORDERS table in the HR schema, following the instructions in "Viewing Tables" on page 8-10.
2. Right-click the PURCHAS E_ORDERS table and select Edit.
The Edit Table dialog box appears.
3. Under the Search box, click Check Constraints.
4. To the right of the Check Constraints section, click Add.
5. In the Name field, entcr PO_CHECK_RCVD_DATE. This constraint namc that you specify will overwrite the system-assigned default name that appears in the Check Constraints text box above the Name field.
6. In the Condition field, enter the following condition for this constraint:
PO_DATE_RECEIVED >= PO_DATE
This expression indicates that PO_DATE_RECEIVED must be greater than or equal to
PO_DATE. For datę columns, this is cquivalcnt to stating that PO_DATE_RECEIVED must be on the same day as, or later than, PO_DATE.
Wyszukiwarka
Podobne podstrony:
DSCF0043 ESSAYS IN SWEDISH HISTORY Charles, whose share in this arrangement would have been limited
74085 IMGx56 284 The Origin of Civilisation In theory, there musi be sonę limit to the number of ris
IMGx56 284 The Origin of Civilisation In theory, there musi be sonę limit to the number of rises tha
rulespage10 STRATEGYI Figurę 5. The player in this example will need to reorganize his Power Structu
Bndging By default, one bridge (brO) is defined and active. In this section you can define additiona
rulespage10 STRATEGYI Figurę 5. The player in this example will need to reorganize his Power Structu
Jak zrobić księżyc ?sy Crescent Moon Tutorial PS by Rach Resources ANG In this example, we // make i
rulespage10 STRATEGYI Figurę 5. The player in this example will need to reorganize his Power Structu
Learning in this course You are expected to attend aH lectures, tutorials, and labs in order to maxi
cp 21 you that herc — later in this book you will fmd the whole story in thc Captain s own words. Th
06 (12) Questions 21 - 40 In this section you must choose the word or phrase which best completes ea
Practical Tips In this chapter, you will find different pattern shapes, a way to convert patter
04 (13) Questions 11-20 • In this section you must choose the word which best fits
Top 10 technical program manager interview ąuestions and answers In this file, you can ref interview
Documenting Disk Properties In this practice, you will document disk properties. You are the systems
więcej podobnych podstron