This example creates a multiset queue table with constraints defined at the column level:
CREATE MULTISET TABLE qtbl_3, QUEUE, NO BEFORE JOURNAL, NO AFTER JOURNAL ( qits TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), col_2 INTEGER, col_3 INTEGER CHECK (col_3 > 10)) PRIMARY INDEX (qits);
This queue table permits duplicate rows. The system uniquely identifies its rows, including duplicates, by their internally-generated ROWID value.