/******************************************************************************
   NAME:       clean_out_lab4X_arms.sql
   PURPOSE:    This script will remove all records from the lab schema
   ADDITIONAL INFORMATION:

    
   REVISIONS:
   Ver        Date        Author           Description
   ---------  ----------  ---------------  ------------------------------------
   1.1        08/20/2008  M. Jacobsen      - Initial Release
******************************************************************************/
    
-- Remove all entries from Lab schema
delete from CHEMRSLT_COMMENT;
delete from CHEMRSLT_COMMENT_EVENT;
delete from LAB_OBSERVATION_METHOD;
delete from CHEMISTRY_RESULT;
delete from LAB_COMMENT;
delete from LAB_COMMENT_EVENT;
delete from LAB_TEST;
delete from LAB_TEST_PRM;
delete from LAB_PATIENT_VISIT;

commit;

