Re: Confused about "check" style constraunts

From: Stan Brown <stanb_at_panix.com>
Date: 21 Aug 2001 15:57:22 -0400
Message-ID: <9luef2$3iu$1@panix1.panix.com>

In <to59ms694kgg1f_at_news.demon.nl> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> writes:

>You query is correct, but I can't imagine why on earth you would have that
>many check constraints.

Thanks, I created a new version of the table in question, renamed ever so slightly. I then ran the original query, 9 records, a sensible amount. Then I slected all the records from the orignal table inot the new table, and rerean the query.

Still 9 records.

So, it appears that soehow (perhaps export/import ?) I have created many extra constraints on some of my tables (I was able to replicate the probelm on a different table). So, any sugestions as to how to clean this mess up? Received on Tue Aug 21 2001 - 14:57:22 CDT