public CreatePrimaryKey GenerateCreatePrimaryKeyStatement(Table t) { CreatePrimaryKey cpk = new CreatePrimaryKey(); cpk.Table = t; return(cpk); }
public string GenerateCreatePrimaryKeyScript(CreatePrimaryKey CreatePrimaryKeyStatement) { string TmpScript = ""; if (CreatePrimaryKeyStatement.Table.PrimaryKeyName != String.Empty) { TmpScript += "alter table " + CreatePrimaryKeyStatement.Table.TableName + Environment.NewLine; TmpScript += " add constraint " + CreatePrimaryKeyStatement.Table.PrimaryKeyName + Environment.NewLine; TmpScript += " primary key (" + Environment.NewLine; foreach (string colName in CreatePrimaryKeyStatement.Table.PrimaryKeyColumns) { //Column c = CreatePrimaryKeyStatement.Table.FindColumn(colName); TmpScript += " " + colName; if (CreatePrimaryKeyStatement.Table.PrimaryKeyColumns.IndexOf(colName) != CreatePrimaryKeyStatement.Table.PrimaryKeyColumns.Count - 1) { TmpScript += "," + Environment.NewLine; } else { TmpScript += Environment.NewLine + " )" + Environment.NewLine; }; } } return(TmpScript); }