private void columns_removeConstraint_remove_button_Click(object sender, EventArgs e)
{
var tableName = dash_tables_listBox.SelectedItem?.ToString();
var constraint = columns_removeConstraint_constraints_listBox.SelectedItem?.ToString();
if (string.IsNullOrWhiteSpace(tableName) || string.IsNullOrWhiteSpace(constraint))
{
HandleError("Table and constraint must be selected.");
return;
}
try
{
_sql.DropTableConstraint($"{dash_statusStrip_schema_value.Text}.{tableName}", constraint, connDto);
WriteToLog("Successfully dropped constraint from table.");
dash_tables_listBox_SelectedIndexChanged(sender, e);
columns_removeConstraint_constraints_listBox.SelectedIndex = -1;
}
catch (Exception ex)
{
HandleError("Error dropping table constraint:", ex);
return;
}
}
