private void columns_remove_removeColumn_button_Click(object sender, EventArgs e)
{
var tableName = dash_tables_listBox.SelectedItem?.ToString();
var columnName = dash_columns_listBox.SelectedItem?.ToString();
if (string.IsNullOrWhiteSpace(tableName) || string.IsNullOrWhiteSpace(columnName))
{
HandleError("Table and column must be selected.");
return;
}
try
{
_sql.DropColumnFromTable($"{dash_statusStrip_schema_value.Text}.{tableName}", columnName.Split(' ')[0], connDto);
WriteToLog($"Successfully dropped {columnName} from {tableName}");
dash_tables_listBox_SelectedIndexChanged(sender, e);
}
catch (Exception ex)
{
HandleError("Error dropping column:", ex);
return;
}
}
