Either delete the constraint, or add "studentid integer" to the table definition.
On Sat, 10 Feb 2024, 23:13 Rick Hillegas, <[email protected]> wrote: > I get the following error when I run this DDL: > > ERROR 42X93: Table 'ACTIVE_LIST' contains a constraint definition with > column 'STUDENTID' which is not in the table. > > > On 2/10/24 6:03 AM, John English wrote: > > CREATE TABLE active_list ( > > username VARCHAR(15) NOT NULL, > > surname VARCHAR(255) NOT NULL, > > initials VARCHAR(255) NOT NULL DEFAULT '', > > email VARCHAR(255) NOT NULL DEFAULT '', > > settings CLOB, > > CONSTRAINT active_pk PRIMARY KEY (username), > > CONSTRAINT active_1 UNIQUE (studentid) > > ) > > >
