
Chapter 5. Building the base scenario: Stage 2 153
);
select * from WPF_ORDXFD;
CREATE TABLE WPF_ORDNOCNT (
ORD_ID VARCHAR (10) NOT NULL ,
PRIMARY KEY (ORD_ID)
);
select * from WPF_ORDXFD;
SELECT COUNT (*) FROM WPF_Param ;
SELECT COUNT (*) FROM WPF_ORG ;
SELECT COUNT (*) FROM WPF_CUST ;
SELECT COUNT (*) FROM WPF_ITEMS ;
SELECT COUNT (*) FROM WPF_ORDERS ;
SELECT COUNT (*) FROM WPF_ORDXFD ;
SELECT COUNT (*) FROM WPF_ORDNOCNT ;
SELECT * FROM WPF_Param ;
SELECT * FROM WPF_ORG ;
SELECT * FROM WPF_CUST ;
SELECT * FROM WPF_ITEMS ;
SELECT * FROM WPF_ORDERS ;
SELECT * FROM WPF_ORDXFD ;
SELECT * FROM WPF_ORDNOCNT ;
The script initially deletes all used tables (DROP stateme ...