Sync delete database

If I delete a database on my main Mac is it deleted automatically on my other synced devices?

No. Only the local copy is deleted.