I am converting an Oracle DB into a SQL DB, and I am trying to modify some of the characteristics in SQL Server (data type, index, etc.), but when I try to make a change (table design window) it tells me"

"Saving changes is not permitted. The changes you have made require the table to be dropped and re-created. You have either made changes to a table that can't be re-created, or enabled the option Prevent saving changes that require the table to be re-created."

There is no reason that the table should not be able to be re-created, and I don't seem to be able to find the option "Prevent" that would keep it from happening.

All help is appreciated!