SQL>
SQL>
SQL> CREATE TABLE suppliers
2 ( supplier_id numeric(4),
3 supplier_name varchar2(50)
4 );
Table created.
SQL>
SQL> ALTER TABLE suppliers
2 add CONSTRAINT check_supplier_name
3 CHECK (supplier_name IN ('A', 'B', 'C'));
Table altered.
SQL>
SQL> ALTER TABLE suppliers
2 enable CONSTRAINT check_supplier_name;
Table altered.
SQL>
SQL>
SQL>
SQL> ALTER TABLE suppliers
2 disable CONSTRAINT check_supplier_name;
Table altered.
SQL>
SQL>
SQL> ALTER TABLE suppliers
2 drop CONSTRAINT check_supplier_name;
Table altered.
SQL>
SQL> drop table suppliers;
Table dropped.
SQL>
|