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