2021-05-31

How do I drop system versioned tables in a sql server database project

We’re using a .net sql server database project to define our database, and it’s not deleting tables from the server even though we have deleted them in the database project. There is an option in the publish profile to drop objects that are in the target but not in the source. However, this doesn’t work for temporal tables as I get an error saying it can’t drop temporal tables as the standard sql drop command is not supported on the temporal table.

Is there a way to drop temporal tables using a SQL server data base project?



from Recent Questions - Stack Overflow https://ift.tt/3yPY9U3
https://ift.tt/eA8V8J

No comments:

Post a Comment