What are the challenges you face when working across database platforms? Take the survey
Options

Drop columns

Hi Team,

Hope you all good,

In our environment I have compared two databases source and target there is a comman table in both database but there is a difference in columns, source have 3 columns for example (A,B and C) target have  3 Columns has(A,B And D),while using Redgate compare from source to target Script generated as below

ALTER TABLE [dbo].[x] DROP COLUMN [D]

I need all columns in target table as it is. Could you please help on the same.

Thanks in advance.
Tagged:

Best Answer

Answers

Sign In or Register to comment.