public void reset()throws TableException{
        String createString;    
        java.sql.Statement stmt;
        
        try{      
            createString = "drop table " + CUSTOMER_TABLE_NAME + ";";
            stmt = sqlConn.createStatement();
            stmt.executeUpdate(createString);
         } catch (java.sql.SQLException e) {
             if (!(e.getMessage().contains("Unknown")))
                System.err.println(e); 
        }
       
        try{
            //Create the CUSTOMER Table
            createString =
            "create table " + CUSTOMER_TABLE_NAME + " " + 
            "(CustomerID integer identity (1,1) NOT NULL, " +
            "FirstName varchar(50) NOT NULL, " +
            "LastName varchar(50) NOT NULL, " +
            "BillAddress integer NOT NULL, " + 
            "ShipAddress integer NOT NULL, " + 
            "EmailAddress varchar(50) NOT NULL, " + 
            "PhoneNumber varchar(13) NULL, " + 
            "OrderIDs integer NULL, " +
            "PRIMARY KEY (CustomerID))";
/*                    
            "FOREIGN KEY (BillAddress) REFERENCES FEARSOME_ADDRESS (AddressID), " + 
            "FOREIGN KEY (ShipAddress) REFERENCES FEARSOME_ADDRESS (AddressID), " + 
            "FOREIGN KEY (OrderIDs) REFERENCES FEARSOME_ORDERS (OrderID)) ";
            * 
            */ 
            stmt = sqlConn.createStatement();
            stmt.executeUpdate(createString);
        } catch (java.sql.SQLException e) {
            throw new TableException("Unable to create " + CUSTOMER_TABLE_NAME + "\nDetaill: " + e);
        }        
    }