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;
}
