I have a table where I deleted several records. As a result, the primary key has holes. For instance 1,2,3, then 5,6,7 and so on.
I want to reorder the primary key, so now it goes as 1 2 3 4 5 6.
Here is the structure of the table:
ID INTEGER PRIMARY KEY, Date TEXT, Number TEXT, Payee TEXT, Memo TEXT, CheckMark TEXT, Amount TEXT, Balance TEXT
Is there any way to change the ID integer primary key so I can reorder it ?
TIA
I want to reorder the primary key, so now it goes as 1 2 3 4 5 6.
Here is the structure of the table:
ID INTEGER PRIMARY KEY, Date TEXT, Number TEXT, Payee TEXT, Memo TEXT, CheckMark TEXT, Amount TEXT, Balance TEXT
Is there any way to change the ID integer primary key so I can reorder it ?
TIA