CODEWITHSUNDEEP
sqlsql-server-2008sql-server-2012
FPGA
FPGA

Reputation: 3855

Alter table schema based on another table

In sql if i had 2 databases where each had similar columns but not exactly the same schema , is there a built in way to alter the schema of a table in database2 make it similar to the schema in of a table database1?

considering that the column type and column name and default value are the factors to decide if 2 columns match.

Upvotes: 1

Views: 433

Answers (1)

steoleary
steoleary

Reputation: 9278

No, there is no built in functionality for doing this, you will either have to do it manually or use a comparison tool such as RedGate SQL Compare or Visual Studio.

Upvotes: 2

Related Questions