Exporting SQL statements from Grid doesn't include actual table name

Toad Edge
1

There is no option to use the actual table name of the data in the grid when exporting it.

steps to reproduce:

  • From a table's data grid select one or more rows.
  • Right click on "Export Selection" and then "SQL...".
  • Export to "SQL - INSERT statements"
  • Next, Next, Next...
  • Review the SQL preview and notice that the insert statements are all "INSERT INTO export" instead of "INSERT INTO actual_table_name"

Only when choosing a Custom name you can change the table name, but this is prone to error and can cause mayor issues in the future.

HOW TO SOLVE THIS:

Make the application read the original tablename and apply it as it source for the export