CREATE TABLE NEWS (
    ID           INTEGER NOT NULL PRIMARY KEY,
    NDATE        DATE NOT NULL,
    NTIME        TIME NOT NULL,
    ID_PROVIDER  INTEGER NOT NULL,
    NEW_NO       CHAR( 35 ) CHARACTER SET NONE,
    SUBJECT      BLOB SUB_TYPE  1  SEGMENT SIZE  80  CHARACTER SET NONE);
ALTER TABLE NEWS ADD FOREIGN KEY (ID_PROVIDER) REFERENCES PROVIDER (ID);

alter table news delete foreign key id_provider

Token unknown - line 1, char 17.
delete.

alter table news drop constraint id_provider

This operation is not defined for system tables.
unsuccessful metadata update.
CONSTRAINT ID_PROVIDER does not exist.