search

pvanek / sqliteman

http://sqliteman.com/
160 stars 58 forks source link

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

Open ghost opened 5 years ago

ghost commented 5 years ago

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.

rparkins999 commented 4 years ago

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.

ghost commented 4 years ago

@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.