SQL Statements › ALTER TABLE › Processing › Example 4

Example 4

Respond to customers' requests to allow financing on small purchases.

1. Table name: ORDERS
2. Remove constraint: ORDERS_MIN_AMT_FINANCED

    EXEC SQL
         ALTER TABLE ORDERS
            DROP CONSTRAINT ORDERS_MIN_AMT_FINANCED
    END-EXEC