Feature: GUI for managing table structure

[bkjohnson]

Right now the GUI only shows me tables and columns and allows me to run my own queries, but it would be great if there was an interface for managing foreign keys, primary keys, default column values, etc. I think it could start out as something fairly simple, like right clicking a table could give you a context menu:

+ Add column
+ Rename Table
+ Drop Table

And right clicking a column could bring up a different context menu:

+ Rename column
+ Change type
+ Add Foreign Key

And each of these options would pop up a modal which would allow you to choose values to be plugged into the specific query.

[BornaP]

There is already something similar, when you click on a table you get a context menu with automatically generated scripts for altering the table. I considered enhancing it with additional features you mentioned, but was never really high priority. Since there are examples in a code how to make context menu, and how to generate custom SQL scripts in sqlectron-core, I highly encourage you to try implement it yourself and possible make a pull request ;) Shouldn't be too complicated.

[bkjohnson]

Sorry for the late reply, I've been very busy lately. I should have some free time in the next two weeks or so, so I'll work on a PR.

[antonioolf]

@BornaP the only options on context menu of tables are:

• Create
• Select
• Insert
• Update
• (and) Delete there is no ALTER TABLE option...

[itma]

Still missing feature. Would be really great to have it.