Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-10854

sql server drop default constraint when dropping column

    XMLWordPrintable

Details

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

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: