private string GetIndexConstraint(FbSchemaIndexes idx) { var fields = ""; foreach (FbSchemaIndexesColumns item in IndexesColumns.Items.Where(x => x.GetName() == idx.Name).OrderBy(y => IntfToIdxColumn(y).Position)) { fields += (!string.IsNullOrEmpty(fields) ? ", " : "") + item.ColumnName; } return($"create {(idx.IndexType == "1" ? "descending " : "")}index {idx.Name} on {idx.TableName}({fields});"); }
private string GetUniqueConstraint(FbSchemaIndexes idx) { var fields = ""; foreach (FbSchemaIndexesColumns item in IndexesColumns.Items.Where(x => x.GetName() == idx.Name).OrderBy(y => IntfToIdxColumn(y).Position)) { fields += (!string.IsNullOrEmpty(fields) ? ", " : "") + item.ColumnName; } return($"alter table {idx.TableName} add constraint {idx.Name} unique ({fields});"); }