Force Table Rebuild

crancodercrancoder Posts: 28
edited January 4, 2008 9:19AM in SQL Compare Previous Versions
Can someone please provide a complete list of the circumstances under which SQL Compare forces a rebuild of a table?

For example, SQL Compare forces a rebuild if the target table has an identity field, but the source table does not.

Thank you.


  • Brian DonahueBrian Donahue Posts: 6,590 New member

    The list is available on our Knowledge Base already. SQL Compare rebuilds tables if one or more of the following is true:
    - Changing an IDENTITY seed or increment value or dropping the IDENTITY property from a column
    - Adding a column in the middle of a table when the 'force column order' option is enabled
    - When you add/alter/drop PERSISTED computed columns
    - When it is impossible to implicitly cast one data type to another (e.g. DECIMAL to NUMERIC)
    - Changing the filegroup specification for a table
    - Changing partitioned columns
  • Brian - Thanks!
Sign In or Register to comment.