How to Loop all tables in Sql Server using Java and extract the data
try{
        // Connection for SQL Server.
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
         String url = "jdbc:sqlserver://"+strDBServer+":1433;DatabaseName="
                 + strDBName + ";" +
               "User="+strDBUser+";Password="+strDBPassword+";";
        Connection conn = DriverManager.getConnection(url);

        if (conn != null) {
            System.out.println("Connection Successful!");
        }

         //XML Transform
        TransformerFactory tFactory = TransformerFactory.newInstance();

        //Create a Statement object
        Statement sql_stmt = conn.createStatement();

        //Get List of all the tables present from Master table.
        ResultSet rs  = sql_stmt.executeQuery("SELECT TableName, Order FROM "
                + strDBName + ".[dbo].Master");


        while (rs.next())
        {
            //Create a Statement object
            Statement sql_stmt_1 = conn.createStatement();

            String strTableName=rs.getString(1).trim();
            int intOrder = rs.getInt(2);

            hsMapTablesFromDB.put(strTableName,intOrder);


            System.out.println("Hashmap --> " + hsMapTablesFromDB);

            ResultSet rs_1  = sql_stmt_1.executeQuery("SELECT Name, LevelOfExistence, UniqueId FROM "
                + strDBName + ".[dbo]." + strTableName);

            String strName = rs_1.getString(1).trim();
            String strUnique = rs_1.getString(3).trim();
            hsMapDataFromIndTable.put(strName,strUnique);

            System.out.println("hsMapDataFromIndTable" + hsMapDataFromIndTable);

        }
    }
    catch(Exception e){
        e.printStackTrace();
    }

select column_name from information_schema.columns
where table_name = 'YourTableName' //this will your iterated loop table name.