Post reply

Compare schema between a table and a view

  • July 19, 2016 at 2:55 pm

    #311850

    So, I've source as view on one database. It loads data to a table in different database. I need to compare the schema between views and tables. I need to be able to do this for about 50 views vs 50 tables. Is there a script for this?

  • July 19, 2016 at 4:21 pm

    #1890968

    SQL_Surfer (7/19/2016)

    So, I've source as view on one database. It loads data to a table in different database. I need to compare the schema between views and tables. I need to be able to do this for about 50 views vs 50 tables. Is there a script for this?

    Views have definitions, rather than schemas.

    Can you provide a simple example (just three or four columns should suffice) of a table definition, a view definition and the results which you would like to see when comparing the two?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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