I'm working on a school project where I have a SQL Server with a database for my team.
I already imported a local database created with Entity Framework.
Now the model has changed, table properties were added/deleted and I want to update my full database.
However, the teachers didn't gave us the create rights so dropping the whole database isn't really an option.
Now is my question, is it possible to drop all the tables currently in the database and just import the newly created one without problems? Or do I really need to drop the whole database?