public void reset()throws TableException{
        String createString;    
        java.sql.Statement stmt;
        
        try{      
            createString = "drop table " + ADDRESS_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 " + ADDRESS_TABLE_NAME + " " + 
            "(AddressID integer identity (1,1) NOT NULL, " +
            "CustomerID integer NOT NULL, " +
            "AddressType varchar(10) NOT NULL, " +
            "Address1 varchar(50) NOT NULL, " +
            "Address2 varchar(50) NULL, " +
            "City varchar(50) NOT NULL, " + 
            "State varchar(50) NOT NULL, " + 
            "Zip integer NOT NULL, " +
            "PRIMARY KEY (AddressID), " + 
            "FOREIGN KEY (CustomerID) REFERENCES FEFO_CUSTOMERS (CustomerID)) ";
            stmt = sqlConn.createStatement();
            stmt.executeUpdate(createString);
        } catch (java.sql.SQLException e) {
            throw new TableException("Unable to create " + ADDRESS_TABLE_NAME + "\nDetaill: " + e);
        }        
    }