Posted by Erland Sommarskog on 10/15/05 00:42

(jbtaylor16@fuse.net) writes:
> I have several default constraints defined on a table. When I use the
> Object Browser and expand the constraints for this table and
> right-click and then select "Script Object to New Window As Create", a
> create constraint statement for a different default constraint is
> displayed than the one I just right-clicked on. For example, I click
> on constraint "DF_C" and it shows me "DF_B".
>
> The last time I encountered this, the solution was to dump contents of
> the table into another, drop, recreate it, and restore the contents.
>
> That's not a good option this time.
>
> Is there another way to fised this or at least navigate the catalog to
> find out what is "off" about this?

Try dropping all the constraints, and then recreate them. It's a little
difficult to say what is going on, as I cannot repro the situation.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]