This is the SQL code I have used thus far:
CREATE TABLE Child_Diary ( Child_ID TEXT(4) CONSTRAINT child_id_no_pk PRIMARY KEY, Room_ID TEXT(25), Date TEXT(25), Time TEXT(25));
However the syntax error is highlighting the 'Date' line. Not sure where I'm going wrong to be honest, I've managed to build all other tables but this one is failing.
I've tried changing the TEXT to INTEGER (just to see if this works) but to no avail.
Can someone shed some light on my error/where I've gone wrong?