July 19, 2016 at 2:55 pm
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
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?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply