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