Re: SQL Alter table: can I remove the UNIQUE attribute from a key?

FWiW the "SQL" is unlikely to have been mentioned by most people even though they are offering an SQL statement. If the likely statement is "SELECT", then use that token instead of "SQL". Anyhow, one possible search:

http://www.google.com/search?q=comparing+union+except+2013+site%3Aarchive.midrange.com%2Fmidrange-l

The above search yielded two threads [plus this one; for obvious reasons] from 2013. One had the "2 days ago" conspicuously noted in the results:
http://archive.midrange.com/midrange-l/201304/msg01365.html
_i Re: Easy way to determine if two tables contain the same data ... i_
archive.midrange.com/midrange-l/201304/msg01365.html
2 days ago ... EXCEPT select * from table2) UNION ALL (select * from table2 ... On Thu, Mar 28,
2013 at 7:28 PM, Charles Wilt <charles.wilt@xxxxxxxxx>wrote: D ... If you have a
need to compare the contents of two tables to determine if ...

Regards, Chuck

On 02 May 2013 12:22, Stone, Joel wrote:

How can I find thread?

I searched

http://archive.midrange.com/midrange-l/index.htm

for "sql union except"

How can SQL compare all fields except the key field WITHOUT naming each field?

CRPence on Thursday, May 02, 2013 2:00 PM wrote:

Why use CMPPFM when SQL can compare the data? The SQL can easily
ignore the /key/ column and compare all of the row data as a SET;
see a very recent message from a somewhat recent thread about
/comparing/ using the EXCEPT in a UNION.