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

Easy Create and Drop query

Open KaungZawHtet opened this issue 5 years ago • 6 comments

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

KaungZawHtet avatar Dec 21 '20 22:12 KaungZawHtet

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

AlexCovizzi avatar Dec 23 '20 14:12 AlexCovizzi

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

KaungZawHtet avatar Dec 23 '20 21:12 KaungZawHtet

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

AlexCovizzi avatar Dec 23 '20 22:12 AlexCovizzi

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

Screen Shot 2020-12-24 at 04 54 52

KaungZawHtet avatar Dec 23 '20 22:12 KaungZawHtet

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?

AlexCovizzi avatar Dec 24 '20 10:12 AlexCovizzi

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.

KaungZawHtet avatar Dec 24 '20 11:12 KaungZawHtet