private String getOneToOneTriggerBody(ForeignKeyDefinition fkDef,

/**

            String exceptionName) {

     * Generates DDL statements for creating a table according to the parameter

        String tableName = fkDef.getTableName();

     * <code>tableDefinition</code>.

     * 

        StringBuffer sb = new StringBuffer();

     * @param tableDefinition

        sb.append("    DECLARE VARIABLE x INTEGER;").append(LINE_SEPARATOR);

     *            A <code>TableDefinition</code> object that holds alls

     *            necessary data for generating code.

        sb.append("BEGIN").append(LINE_SEPARATOR);

     * @return The generated code.

     * @see org.argouml.language.sql.SqlCodeCreator#createTable(org.argouml.language.sql.TableDefinition)

        sb.append("    ");

     */

        sb.append("SELECT COUNT(*) FROM ").append(tableName);

    public String createTable(TableDefinition tableDefinition) {

        sb.append(" WHERE ");

        StringBuffer sb = new StringBuffer();

        sb.append("CREATE TABLE ");

        StringBuffer sbWhere = new StringBuffer();

        sb.append(tableDefinition.getName());

        List columnNames = fkDef.getColumnNames();

        sb.append(" (").append(LINE_SEPARATOR);

        for (int i = 0; i < columnNames.size(); i++) {

            if (sbWhere.length() > 0) {

        Iterator it = tableDefinition.getColumnDefinitions().iterator();

                sbWhere.append(" AND ");

        while (it.hasNext()) {

            }

            ColumnDefinition colDef = (ColumnDefinition) it.next();

            sb.append(colDef.getName()).append(" ");

            String colName = (String) columnNames.get(i);

            sb.append(colDef.getDatatype());

            Boolean nullable = colDef.getNullable();

            sbWhere.append(colName);

            if (nullable != null) {

            sbWhere.append(" = NEW.").append(colName);

                if (nullable.equals(Boolean.TRUE)) {

        }

                    sb.append(" ").append("NULL");

                } else if (nullable.equals(Boolean.FALSE)) {

        List pkFields = fkDef.getTable().getPrimaryKeyFields();

                    sb.append(" ").append("NOT NULL");

        for (int i = 0; i < pkFields.size(); i++) {

                }

            String pkFieldName = (String) pkFields.get(i);

            }

            sbWhere.append(" AND ").append(pkFieldName);

            sb.append(",").append(LINE_SEPARATOR);

            sbWhere.append(" <> NEW.").append(pkFieldName);

        }

            sbWhere.append(" ");

        }

        StringBuffer sbPk = new StringBuffer();

        it = tableDefinition.getPrimaryKeyFields().iterator();

        sb.append(sbWhere).append(" INTO :x;").append(LINE_SEPARATOR);

        while (it.hasNext()) {

            String primaryKeyField = (String) it.next();

        sb.append("    IF (:x = 1) THEN").append(LINE_SEPARATOR);

            if (sbPk.length() > 0) {

                sbPk.append(", ");

        sb.append("        ");

            }

        sb.append("EXCEPTION ").append(exceptionName);

            sbPk.append(primaryKeyField);

        sb.append(";").append(LINE_SEPARATOR);

        }

        sb.append("END !!").append(LINE_SEPARATOR);

        sb.append("PRIMARY KEY (");

        sb.append(sbPk);

        return sb.toString();

        sb.append(")").append(LINE_SEPARATOR);

    }

        sb.append(");");

        primaryKeyCounter++;

        return sb.toString();

    }