Easy Create and Drop query

[KaungZawHtet]

Thank you for your awesome extension. I want to ask a feature request:

Can we get Create Table and 'Drop Table' query option from existing table when right clicking it

[AlexCovizzi]

I can add a Drop Table option, but I'm not really sure how I could add a Create Table option in a useful way

[KaungZawHtet]

Create Table is useful for query-based code generations. This is example. I can directly copy the query into moor file for code generation .

[AlexCovizzi]

Do you mean providing the query to create an already existing table? Because in that case they are already available from the sqlite_master table and there is a Show sqlite_master option to show it

[KaungZawHtet]

For Better UX. Here is popup when when I click a table at Native sqlite manager. Sqlite pro gives sort of those features too.

[AlexCovizzi]

I'm not familiar with those tools and I don't have the environment to try them, can you expand on what the options CREATE To and DROP To do in this case?

[KaungZawHtet]

After click that create to and drop to , the query related to that table appear in editor. Your extension has that feature too but only for select and insect. Another thing is that ur new query(Select&Insert)should append in existing query tab. It is currently generating new tab every time I click the option.