@Override public String getViewDDL(DBRProgressMonitor monitor, GenericTable sourceObject) throws DBException { GenericDataSource dataSource = sourceObject.getDataSource(); try (JDBCSession session = DBUtils.openMetaSession(monitor, dataSource, "Read H2 view source")) { try (JDBCPreparedStatement dbStat = session.prepareStatement( "SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS " + "WHERE TABLE_SCHEMA=? AND TABLE_NAME=?")) { dbStat.setString(1, sourceObject.getContainer().getName()); dbStat.setString(2, sourceObject.getName()); try (JDBCResultSet dbResult = dbStat.executeQuery()) { if (dbResult.nextRow()) { return dbResult.getString(1); } return "-- H2 view definition not found"; } } } catch (SQLException e) { throw new DBException(e, dataSource); } }