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

Ignore DEFAULT statements?

tkdennistkdennis Posts: 114
I'm trying to compare just the column names and data types between two databases. I checked every option under "Ignore" on the Options tab.
Many tables in one database have DEFAULT statements on the columns and these are causing the tables to be considered different. Is there a way to ignore the DEFAULT part?

date_entered datetime NOT NULL DEFAULT (getdate())

comparing to

date_entered datetime NOT NULL

Thanks,
Traci
Tagged:

Comments

Sign In or Register to comment.