At Sql Server Management studio sometime We run queries that changes table properties or structure.
At this point We get an error message that says something like:
“Please drop and recreate table…”.
The solution for it is here:
SQL SERVER – ENABLE QUERIES THAT REQUIRE TABLE RECREATION