Post reply

Query for datatype difference

  • September 5, 2011 at 8:31 am

    #244261

    I have two tables A and B

    Table A contains few tables with there columns, datatypes & datatype length

    Table B contains same few tables with there columns, datatypes & datatype length but in different database [and there might be few differences in the table structure]

    The column names in both tables is Table name, column name, data type and length.

    How can i show any difference in datatype for any column across the tables ? There might be more columns for a table in table A as compared to table B or vice versa.

  • September 5, 2011 at 11:08 am

    #1377112

    You could get the relevant rows from sys.columns of db_B and db_A and compare those (e.g. using a full outer join on sys.columns.name).


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply