public List<string> GenerateRenameColumnStatement(RenameColumn renameColumn) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("ALTER TABLE {0} RENAME COLUMN {1} TO {2}", renameColumn.Table, renameColumn.OldName, renameColumn.NewName); return new List<string>() { sb.ToString() }; }
public List<string> GenerateRenameColumnStatement(RenameColumn renameStatement) { List<string> result = new List<string>(); string sqlExpression = string.Format("@@@HM_DROP_COLUMN_OBJECTS {0}.{1}@@@", renameStatement.Table, renameStatement.OldName); result.Add(sqlExpression); sqlExpression = string.Format("ALTER TABLE {0} ADD {1} {2} {3} DEFAULT {4}", renameStatement.Table, renameStatement.NewName, renameStatement.DataType, renameStatement.Nullable ? "NULL" : "NOT NULL", renameStatement.Default); result.Add(sqlExpression); sqlExpression = string.Format("UPDATE {0} SET {1} = {2}", renameStatement.Table, renameStatement.NewName, renameStatement.OldName); result.Add(sqlExpression); sqlExpression = string.Format("ALTER TABLE {0} DROP COLUMN {1}", renameStatement.Table, renameStatement.OldName); result.Add(sqlExpression); return result; }
public List<string> GenerateRenameColumnStatement(RenameColumn statement) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("ALTER TABLE {0} CHANGE {1} {2} {3} {4}", statement.Table, statement.OldName, statement.NewName, statement.DataType, statement.Nullable ? "NULL" : "NOT NULL" ); return new List<string>() { sb.ToString() }; }
public List<string> GenerateRenameColumnStatement(RenameColumn renameColumn) { StringBuilder sb = new StringBuilder(); sb.AppendFormat("sp_rename '{0}.{1}', '{2}', 'COLUMN'", renameColumn.Table, renameColumn.OldName, renameColumn.NewName); return new List<string> () {sb.ToString()}; }
private IStatement ParseRenameColumnStatement(XmlNode statement) { RenameColumn renameStatement = new RenameColumn(); renameStatement.Table = statement.Attributes["Table"].Value; renameStatement.OldName = statement.Attributes["OldName"].Value; renameStatement.NewName = statement.Attributes["NewName"].Value; renameStatement.DataType = statement.Attributes["DataType"].Value; renameStatement.Nullable = Convert.ToBoolean(statement.Attributes["Nullable"].Value); renameStatement.Default = statement.Attributes["Default"].Value; return renameStatement; }