//删除整个表

-(void)dropTable

{

NSString *dropsql = [NSString stringWithFormat:@"drop table student"];

//执行

int result = sqlite3_exec(db,dropsql.UTF8String,NULL,NULL);

if (sqlITE_OK == result) {

NSLog(@"已删除整个表");

}

else

{

NSLog(@"删除失败,%d",result);

}

}