아미(아름다운미소)

SQLite autoincrement 초기화 본문

데이타베이스/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'; 
Comments