There is the option:
Use DROP and CREATE instead of ALTER
When this option is selected, SQL Compare replaces ALTER statements in the deployment script with DROP and CREATE statements for the following objects:
This setting does not however apply to Tables
You can request features for this product in our uservoice forums.
http://redgate.uservoice.com/forums/141 ... uggestions
These forums are monitored by our developers and allow our users to request features and vote on them.
If a request receives significant support the feature may be included in a future release.