Removing a table form SQLite DB

user6438798

Hi,

Publication contains a couple of tables. I removed one of them, Started msync on the client, but the table remained in the SQLite database.

How can I remove this table from SQLite?

The original reason was: I wanted to extend primary key of this table, but I got synchronization errors. So I decided first to remove it , and later add to the publication.

thanks

Zoltán

Winnie.Hu-Oracle

One more note: After you make modification to the publication, you need to do a complete refresh. A complete refresh can be triggered via: a) delete the databases on the client side and sync again, or b) set the complete refresh option on the mSync program.

Thanks,
Winnie

Winnie.Hu-Oracle

Hi Zoltán,

You need to remove the corresponding publication item (mapping the table in question) from the publication to remove the table. The synchronization will pull down all the tables in the publication to the client side. To remove the publication item, use either the MDW or Consolidator API.

Regards,

Winnie

Oracle Database Mobile Server team

Winnie.Hu-Oracle

One more note: After you make modification to the publication, you need to do a complete refresh. A complete refresh can be triggered via: a) delete the databases on the client side and sync again, or b) set the complete refresh option on the mSync program.

Thanks,
Winnie

user6438798

Thanks, Complete refresh was missing.

Zoltán