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