internal override string generateCreateSql()
{
/*
* Oracle> ALTER TABLE aact ADD CONSTRAINT FK_AACT_ACID FOREIGN KEY (ACID) REFERENCES ACC (ACID)
*/
StringBuilder sb = new StringBuilder();
sb.Append("ALTER TABLE ")
.Append(FullTableName.ToUpper())
.Append(@" ADD CONSTRAINT ")
.Append(ConstraintName.ToUpper()) // oracle doesn't like the schema name put here, so we use the constraint name only
.Append(@" FOREIGN KEY (");
foreach (FieldInfo fi in this.SourceFields)
{
sb.Append(fi.Name).Append(@", ");
}
sb.Remove(sb.Length - 2, 2);
sb.Append(@") REFERENCES ")
.Append(this.ReferencesFullTableName.ToUpper())
.Append(@" (");
foreach (FieldInfo fi2 in this.ReferencesFields)
{
sb.Append(fi2.Name).Append(", ");
}
sb.Remove(sb.Length - 2, 2);
sb.Append(")"); // ON DELETE RESTRICT ON UPDATE RESTRICT)");
string ret = sb.ToString();
return(ret);
}
internal override string generateCreateSql()
{
/*
* CREATE [UNIQUE] INDEX index_name ON
* table_name(column_name[, column_name...])
* TABLESPACE table_space;
*/
StringBuilder sb = new StringBuilder();
StringBuilder sbPKs = new StringBuilder();
sb.Append("CREATE ")
.Append((IndexKind == null ? "" : IndexKind))
.Append(" INDEX ")
.Append((IndexName == null ? "" : FullIndexName.ToUpper()))
.Append(" ");
sb.Append(" ON ")
.Append(FullTableName.ToUpper())
.Append(" (");
foreach (FieldInfo fi in Fields)
{
// sb.Append(@"""").Append(fi.Name).Append(@""", ");
sb.Append(fi.Name).Append(", ");
}
if (Fields.Count > 0)
{
sb.Remove(sb.Length - 2, 2);
}
sb.Append(")");
string ret = sb.ToString();
return(ret);
}
protected override string generateDropSql()
{
return("ALTER TABLE " + FullTableName.ToUpper() + " DROP CONSTRAINT " + FullConstraintName.ToUpper());
}
