SQL 2008 prevents schema changes if the table must be dropped
When editing the table schema in the SQL Server 2008 UI and the required change requires that the table needs to be dropped and recreated by default the UI will not let you make the change. The kinds of changes that would require that the table be dropped and recreated would be inserting a column in […]