sql - Sturctured Query Language -

sql - Sturctured Query Language -

create table customer( custno number(10) constraint foo primary key, custname character(15), city character(15), phone number(10)); create table invoice( invo number(10) constraint inv primary key, invdate date(10), constarint c references customer(custno));

i cannot able create sec table , having uncertainty of info type date , if neglected attribute(invdate) still cannot able create sec table.reason please.

create table client ( custno int constraint foo primary key ,custname character(15) ,city character(15) ,phone int ) go create table invoice ( invo int constraint inv primary key constraint ck references customer(custno) ,invdate date )

sql