/** * Computes the SQL statement to alter a table and add a column to it. * * @param column the column to add * @return the SQL alter table string */ @Override public String getAddColumnSql(Column column) { StringBuilder buf = new StringBuilder(); buf.append("ALTER TABLE "); buf.append(getQuotedName()); buf.append(' '); buf.append(dialect.getAddColumnString()); buf.append(' '); addOneColumn(buf, column); return buf.toString(); }
/** * Computes the SQL statement to create the table. * * @return the SQL create string. */ @Override public String getCreateSql() { StringBuilder buf = new StringBuilder(); buf.append("CREATE TABLE "); buf.append(getQuotedName()); buf.append(" ("); String custom = dialect.getCustomColumnDefinition(this); if (custom != null) { buf.append(custom); buf.append(", "); } for (Iterator<Column> it = columns.values().iterator(); it.hasNext();) { addOneColumn(buf, it.next()); if (it.hasNext()) { buf.append(", "); } } // unique // check buf.append(')'); buf.append(dialect.getTableTypeString(this)); return buf.toString(); }