Affects Version/s: 2.2.2
Fix Version/s: None
Security Level: All
Environment:MS SQL Server + Windows Server 2008
Whenever Doctrine tries to drop a column that has some implicit constraints the system the SQL Native Client throws the message:
The Object 'Name_Of_The_Object' is dependent on column 'Column_To_Drop';
This is probably because columns such as Decimal Numbers have an automatice generated constraint that need to be dropped in order to drop a column.
A possible Solution is to add a platform specific getConstratintForTableSQL that queries the database to get all the constraint for the given column, than override the 'alterTable' method in the SQLServer Schema Manager to first drop the constraint than the columns in question by going and checking all the Columns that needs to be dropped in the TableDiff passed.
Something similar to this but better refactored I guess:
Changes in SQLServerPlatform.php
Add a method similar to this:
Changes on SqlServerChemaManager.php
Hope this helps