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 INTOactual_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