@Override public String getCreateSQLForCopy(Table forTable, String quotedName) { StringBuilder buff = new StringBuilder("ALTER TABLE "); buff.append(forTable.getSQL()).append(" ADD CONSTRAINT "); if (forTable.isHidden()) { buff.append("IF NOT EXISTS "); } buff.append(quotedName); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } buff.append(" CHECK").append(StringUtils.enclose(expr.getSQL())) .append(" NOCHECK"); return buff.toString(); }
text += "(DISTINCT " + on.getSQL() + ')'; } else { text += StringUtils.enclose(on.getSQL());
public String getCreateSQLForCopy(Table table, String quotedName) { StringBuffer buff = new StringBuffer(); buff.append("ALTER TABLE "); buff.append(table.getSQL()); buff.append(" ADD CONSTRAINT "); buff.append(quotedName); if (comment != null) { buff.append(" COMMENT "); buff.append(StringUtils.quoteStringSQL(comment)); } buff.append(" CHECK"); buff.append(StringUtils.enclose(expr.getSQL())); buff.append(" NOCHECK"); return buff.toString(); }
@Override public String getCreateSQLForCopy(Table forTable, String quotedName) { StringBuilder buff = new StringBuilder("ALTER TABLE "); buff.append(forTable.getSQL()).append(" ADD CONSTRAINT "); if (forTable.isHidden()) { buff.append("IF NOT EXISTS "); } buff.append(quotedName); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } buff.append(" CHECK").append(StringUtils.enclose(expr.getSQL())) .append(" NOCHECK"); return buff.toString(); }
@Override public String getCreateSQLForCopy(Table forTable, String quotedName) { StringBuilder buff = new StringBuilder("ALTER TABLE "); buff.append(forTable.getSQL()).append(" ADD CONSTRAINT "); if (forTable.isHidden()) { buff.append("IF NOT EXISTS "); } buff.append(quotedName); if (comment != null) { buff.append(" COMMENT ").append(StringUtils.quoteStringSQL(comment)); } buff.append(" CHECK").append(StringUtils.enclose(expr.getSQL())) .append(" NOCHECK"); return buff.toString(); }
return text + "(DISTINCT " + on.getSQL() + ")"; } else { return text + StringUtils.enclose(on.getSQL());
return text + "(DISTINCT " + on.getSQL() + ")"; return text + StringUtils.enclose(on.getSQL());
return text + "(DISTINCT " + on.getSQL() + ")"; return text + StringUtils.enclose(on.getSQL());