private void btnLoadScript_Click(object sender, EventArgs e)
{
var tables = dbHandler.GetTableDDL(cmbTables.SelectedItem.ToString(), cmbSchemasDelete.SelectedItem.ToString());
richTextBox1.Text = "Table " + cmbTables.SelectedItem.ToString() + "\n";
foreach (String str in tables)
{
richTextBox1.Text += "\t" + str + "\n";
}
richTextBox1.Text += "\n\t ------ INDEXES ------\n\n";
//VERY SMART CODE!!!!!!!!!!! I managed to use an existing code, adding a part of the query and eliminating the rest of the query by using comments
var indexes = dbHandler.GetSchemaIndexes(cmbSchemasDelete.SelectedItem.ToString() + "' and Tablename = '" + cmbTables.SelectedItem.ToString() + "';//");
foreach (String str in indexes)
{
richTextBox1.Text += "\t" + str + "\n";
var indexFields = dbHandler.GetIndexFields(str, cmbSchemasDelete.SelectedItem.ToString());
richTextBox1.Text += "\t-----ON FIELDS------ \n";
foreach (string strField in indexFields)
{
richTextBox1.Text += "\t\t" + strField + "\n";
}
richTextBox1.Text += "\t-----END------ \n\n";
}
}
