Home Forums SQL Server 2005 T-SQL (SS2K5) Compare Table structure in two databases in sql server 2005 RE: Compare Table structure in two databases in sql server 2005

  • December 9, 2008 at 8:15 pm

    #910038

    Here's a start:

    Print 'changed in New:'

    Select * from MyTests.INFORMATION_SCHEMA.COLUMNS

    EXCEPT

    Select * from Util.INFORMATION_SCHEMA.COLUMNS

    Print 'changed from Old :'

    Select * from Util.INFORMATION_SCHEMA.COLUMNS

    EXCEPT

    Select * from MyTests.INFORMATION_SCHEMA.COLUMNS

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]