Ravi_40 Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.80K
1 Posted Topic
CREATE TABLE SALESORDER( ORDERNO VARCHAR(6) PRIMARY KEY CHECK(ORDERNO LIKE 'O%'), CLIENT_NO VARCHAR(6) FOREIGN KEY REFERENCES CLIENT_MAST(CLIENTNO), ORDERDATE DATE NOT NULL, DELYADDR VARCHAR(25), SALESMANNO VARCHAR(6) FOREIGN KEY REFERENCES SALESMAN_MAST(SALESMANNO), DELYTYPE CHAR(1), BILLYN CHAR(1), DELYDATE DATE CHECK(BELYDATE > ORDERDATE), ORDERSTATUS VARCHAR(10) CHECK(ORDERSTATUS IN('PROCESS','FULFILLED,'BACKORDER,'CANCELLED')) ); IT GENRATE BELOW ERROR HOW TO SOLVE IT: …
The End.