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 IRenameColumnOfTable Column(string columnName)
{
var action = new RenameColumn(_dataClient, columnName);
FireOnAction(action);
return(action);
}
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);
}
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 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 IRenameColumnOfTable Column(string columnName) {
var action = new RenameColumn(_dataClient, columnName);
FireOnAction(action);
return action;
}
