[Firebird-test] Is this what you are looking for

[Steve L. <st...@sl...>]

Is this the type of thing you are looking for?


CREATE TABLE FB_TEST(FB_ID INTEGER NOT NULL,
FB_DATA VARCHAR(20),
CONSTRAINT FB_ID_PK PRIMARY KEY (FB_ID));

INSERT INTO FB_TEST(FB_ID, FB_DATA)
VALUES(1, 'RECORD ONE');

INSERT INTO FB_TEST(FB_ID, FB_DATA)
VALUES(2, 'RECORD TWO');

INSERT INTO FB_TEST(FB_ID, FB_DATA)
VALUES(2, 'RECORD TWO');

/*RESULT
Statement failed, SQLCODE = -803
violation of PRIMARY or UNIQUE KEY constraint "FB_ID_PK" on table "FB_TEST"
*/