Why does Symfomy 4 give an error when changing the schema via the command line and how to solve this problem?

Question

symfony

In symfomy, I created a Many to many relationship, because of it it gives an error when calling the command: php bin/console doctrine:schema:update --force
Relationship in entity agents:

/**
     * Many Realties have Many Agents.
     *
     * @ManyToMany(targetEntity="App\Metrag\AppBundle\Entity\Realty")
     * @JoinTable(name="agent_realties",
     *      joinColumns={@JoinColumn(name="agent_id", referencedColumnName="id", onDelete="CASCADE")},
     *      inverseJoinColumns={@JoinColumn(name="realty_id", referencedColumnName="id", onDelete="CASCADE")}
     * )
     */
    private $realties;

Mistake:

In SchemaException.php line 112:
                                              
  The table with name 'default.agent_realties' already exists.

Addition: the error appears even if you delete the table in the database.

Answer 1

Found a solution.
It looks like you already have a table named "agent_realties" in that database. Remove this line @ORM\JoinTable(name="agent_realties") and try without it.