Microsoft SQL Server forum - Wrong default constraint shown from Object Browser in Query Analyser

Author

Wrong default constraint shown from Object Browser in Query Analyser

jbtaylor16@fuse.net

2005-10-27, 9:24 am

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?

Thanks

Erland Sommarskog

2005-10-27, 9:24 am

(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/techin.../2000/books.asp

Sponsored Links