Is there an easy way to drop UNIQUE attribute from an SQlite table column?

Question

I've googled and it says I am to create a same structure table without UNIQUE, copy the data, then drop the old table, then rename the new table to the old name.

While I can do that, I wonder if it can be done easier?

score 1 · Accepted Answer · edited May 23 '17 at 12:22

1

Check the accepted answer on this link: How to delete or add column in SQLITE?

It seems like SQLite removes a lot of the ALTER TABLE functionality that would usually let you do those kinds of operations in "regular" SQL.

edited May 23 '17 at 12:22

Community

1
1

answered Mar 13 '15 at 21:02

Is there an easy way to drop UNIQUE attribute from an SQlite table column?

1 Answers1