vscode-sqlite icon indicating copy to clipboard operation
vscode-sqlite copied to clipboard

Published 20 hours ago • verified publisher icon AlexCovizzi

Add command for drop & create query in explorer.

Open jeffesp opened this issue 4 years ago • 4 comments

CHANGES:

  • Saves the table/view definition when the database is loaded.
  • Added a command to explorer items menus to generate a query with "DROP" statement followed by the original "CREATE" statement saved when the database is loaded.

jeffesp avatar Feb 27 '21 18:02 jeffesp

Hi @jeffesp! Thanks for the contribution! Can you separate the DROP query and the CREATE query in two different commands as suggested in #145?

AlexCovizzi avatar Mar 07 '21 15:03 AlexCovizzi

I find this form more useful, but will update if that's what gets the patch merged. This was more scratching my own itch than addressing a particular bug.

jeffesp avatar Mar 08 '21 02:03 jeffesp

I see, can I ask you how you use the generated DROP&CREATE query? Do you generate it and then just run it or do you copy and paste it on other code or something else?

AlexCovizzi avatar Mar 10 '21 16:03 AlexCovizzi

Generally, I generate it and then I edit it and run it. This is useful when working on a VIEW as it just drops and creates the thing that I was editing.

jeffesp avatar Mar 12 '21 22:03 jeffesp