private void GetNullableSqlToRenameColumnCommand(string columnName, SqlColumnStructure colStructure, StringBuilder builder, string alterColumn) { var colNullable = colStructure.Nullable; if (!String.IsNullOrEmpty(colNullable)) { var action = colNullable == _wordNotNull ? "SET" : "DROP"; builder.AppendFormat("{0} {1} {2} {3},", alterColumn, columnName, action, _wordNotNull); } }
private static void GetTypeSqlToRenameColumnCommand(string columnName, SqlColumnStructure colStructure, StringBuilder builder, string alterColumn) { var colType = colStructure.Type; if (!String.IsNullOrEmpty(colType)) { builder.AppendFormat("{0} {1} TYPE {2} USING {1}::{2},", alterColumn, columnName, colType); } }
private static void GetDefaultValueSqlToRenameColumnCommand(string columnName, SqlColumnStructure colStructure, StringBuilder builder, string alterColumn) { var colDefault = colStructure.Default; if (!String.IsNullOrEmpty(colDefault)) { builder.AppendFormat("{0} {1} SET {2},", alterColumn, columnName, colDefault); } }