Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-10854

sql server drop default constraint when dropping column

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.0.12-RC1
    • 3.0.10, 3.1.0-dev
    • None
    • SQL Server 2008 R2 (express and enterprise), zend server 5.6, phpbb 3.0.10

      when using UMIL with sql server then the script will break when dropping column, mentioning an error like this in UMIL.

      Msg 5074, Level 16, State 1, Line 1
      The object 'DF_RproleIsClo_4BCC3ABA' is dependent on column 'IsClosed'.
      Msg 4922, Level 16, State 9, Line 1
      ALTER TABLE DROP COLUMN IsClosed failed because one or more objects access this column.

      This happens because of "DEFAULT" constraints which is always the case when not adding one specifically
      see http://stackoverflow.com/questions/314998/sql-server-2005-drop-column-with-constraints

      solution is to drop default constraint before dropping column. in Oracle this is simply "DROP COLUMN xxx CASCADE CONSTRAINTS" but in SQL server the only solutions seems to be a T-SQL script.

            EXreaction EXreaction [X] (Inactive)
            Sajaki Sajaki
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: