protected override void EmitAlterColumnDefinition(SQL.AlterColumnDefinition column) { if (column.DomainName != null) { AppendFormat("{0} {1} ", SQL.Keywords.Alter, SQL.Keywords.Column); EmitIdentifier(column.ColumnName); AppendFormat(" type {0}", column.DomainName); if (column.AlterNullable) { Append(", "); } } if (column.AlterNullable) { AppendFormat("{0} {1} ", SQL.Keywords.Alter, SQL.Keywords.Column); EmitIdentifier(column.ColumnName); if (column.IsNullable) { AppendFormat(" set {0}", SQL.Keywords.Null); } else { AppendFormat(" set {0} {1}", SQL.Keywords.Not, SQL.Keywords.Null); } } }
protected virtual void EmitAlterColumnDefinition(AlterColumnDefinition column) { AppendFormat("{0} {1} ", Keywords.Alter, Keywords.Column); EmitIdentifier(column.ColumnName); if (column.DomainName != null) { AppendFormat(" {0}", column.DomainName); } if (column.AlterNullable) { if (column.IsNullable) { AppendFormat(" {0}", Keywords.Null); } else { AppendFormat(" {0} {1}", Keywords.Not, Keywords.Null); } } }
protected override void EmitAlterTableStatement(SQL.AlterTableStatement statement) { Indent(); AppendFormat("{0} {1} ", SQL.Keywords.Alter, SQL.Keywords.Table); EmitIdentifier(statement.TableName); for (int index = 0; index < statement.AddColumns.Count; index++) { AppendFormat(" {0} {1}", SQL.Keywords.Add, SQL.Keywords.BeginGroup); EmitColumnDefinition(statement.AddColumns[index]); Append(SQL.Keywords.EndGroup); } for (int index = 0; index < statement.AlterColumns.Count; index++) { SQL.AlterColumnDefinition definition = statement.AlterColumns[index]; if (definition.AlterNullable) { AppendFormat(" {0} ", "modify"); EmitIdentifier(definition.ColumnName); if (definition.IsNullable) { AppendFormat(" {0}", SQL.Keywords.Null); } else { AppendFormat(" {0} {1}", SQL.Keywords.Not, SQL.Keywords.Null); } } } for (int index = 0; index < statement.DropColumns.Count; index++) { AppendFormat(" {0} {1}", SQL.Keywords.Drop, SQL.Keywords.BeginGroup); EmitIdentifier(statement.DropColumns[index].ColumnName); Append(SQL.Keywords.EndGroup); } }