sqliteman icon indicating copy to clipboard operation
sqliteman copied to clipboard

Feature request: make it possible to add unique constraints from the GUI

Open ghost opened this issue 6 years ago • 2 comments

Now my only option is to resort to manually writing SQL (and copypaste create table queries for adding unique constraints to existing tables). I would like to be able to do it easier, from the GUI, for both new and existing tables.

ghost avatar Jan 11 '19 07:01 ghost

I think that pvanek is no longer actively maintaining this version. If you use the Linux version, or can build a Windows version from the sources, raise this issue against rparkins999/sqliteman. I'll take a look at adding unique constraints to table creation when I have time. Adding unique constraints when altering a table is much more difficult, because multiple rows already in the table may have the same value for the key.

rparkins999 avatar Feb 28 '20 12:02 rparkins999

@rparkins999 I spent one hour trying to remember why I made this feature request and couldn't. Surely I needed it for some small pet project of mine, but I really can't remember any details. And I surely didn't need it again after that, so feel to assign a very low priority to it if you think it's worth adding.

ghost avatar Feb 28 '20 13:02 ghost