![]() ![]() If users never see the primary key value (they shouldn't, because the data can change & won't always be at that primary key value), I wouldn't bother with these options. In either case, the database doesn't care if the id numbers are sequencial - only that the values are unique. Make sure you know what you are doing before you undertake such changes.įound the answer on SO: SQLite Reset Primary Key Field MySQL AutoCount Accounting 2.0The enhanced version of AutoCount Accounting V2 includes lots of new features and enhancements to make your experience better than ever.FeatureMaintain up to 6 selking prices for each item and by debtor's level. But making modifications to this table will likely perturb the AUTOINCREMENT key generation algorithm. The content of the SQLITE_SEQUENCE table can be modified using ordinary UPDATE, INSERT, and DELETE statements. The SQLITE_SEQUENCE table is created and initialized automatically whenever a normal table that contains an AUTOINCREMENT column is created. ![]() (A check mark will indicate the default data file.) Click Close. SQLite keeps track of the largest ROWID that a table has ever held using the special SQLITE_SEQUENCE table. Select the Data Files tab in the Account Settings dialog box, and then note the name and location of the default data file for your profile. DELETE FROM sqlite_sequence WHERE name = 'your_table'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |