Database Reference
In-Depth Information
Sales.CountryRegionCurrency table, and so a reference constraint-related
exception will occur, as shown in Figure 13-13.
Figure 13-13.
Delete statement showing reference constraint conflict
14.
Click OK. As you have seen, you can't delete the currencies that have
referenced entries in the Sales.CountryCurrencyRegion table. Hence, you can
only delete the entry that is not related to this referencing table. In the
CommandNonQuery exercise, you inserted a CurrencyCode called US, as
shown in Figure 13-9. Scroll the currency list until you see US, and then click
the Delete Currency button. You will see the successful deletion of the
currency, as shown in Figure 13-14.
Figure 13-14.
Successful deletion of the currency
