Check Constraint

How can i change a check constraint of a table :
example:
CREATE TABLE MEDIA
(mediaNr INTEGER PRIMARY KEY,

   object BLOB NOT NULL,
   playtime INTEGER NOT NULL,
  mediatype VARCHAR2(10),

         constraint media_type_check
  check (mediatype in ('Audio', 'Video', 'Picture')));

in
CREATE TABLE MEDIA
(mediaNr INTEGER PRIMARY KEY,

   object BLOB NOT NULL,
   playtime INTEGER NOT NULL,
  mediatype VARCHAR2(10),

         constraint media_type_check
  check (mediatype in ('Audio', 'Video', 'Picture', 'Macromedia','Executables')));

Is there an ALTER TABLE MODIFY CONSTRAINT available??

Thanks

Received on Tue Aug 17 1999 - 00:13:53 CDT