데이타베이스/SQLite
SQLite autoincrement 초기화
유키공
2019. 2. 9. 12:46
<>SQLite autoincrement 초기화 - 시퀀스 초기화(or 재설정)
DELETE FROM TABLE_NAME; DELETE FROM SQLITE_SEQUENCE WHERE NAME ='TABLE_NAME'; #OR UPDATE SQLITE_SEQUENCE SET SEQ=0 WHERE NAME = 'TABLE_NAME'; #OR UPDATE SQLITE_SEQUENCE SET SEQ = N WHERE NAME = 'TABLE_NAME';