SQL Recipes
A FREE cookbook for SQL queries and examples
Register FAQ Search Today's Posts Mark Forums Read

SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it.

Go Back   SQL Recipes a FREE cookbook of SQL queries and examples > SQL queries and examples > SQL - Questions and Answers
Schema Compare using information Schema Views Schema Compare using information Schema Views

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
  #1 (permalink)  
Old 01-31-2008, 07:50 PM
brekher brekher is offline
Junior Member
  
Join Date: Jan 2008
Posts: 1
brekher is on a distinguished road
Default ANY dialect question:

Schema Compare using information Schema Views

Hi,
I need to compare the structure of 2 tables within the same database to make sure they are the same before I load data into one of them. I am currently obtaining values from the information schema views but how can I compare 1 vs. the other? Any help would be appreciated. Thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Be the first to answer this question! Click on the 'Post Reply' button below.
Reply

« Checking whether values in one table are missing from grouping in 2nd table | How do i compare NUMBER to VARCHAR? »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may post new threads
You may post replies
You may not post attachments
You may edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 06:04 PM.

Contact Us - SQL Recipes - Archive - Top

Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0
Copyright (c) 2006-2008 SQL Recipes

1 2 3 4 5 6 7 8