Groups | Blog | Home
all groups > sql server (alternate) > october 2005 >

sql server (alternate) : Wrong default constraint shown from Object Browser in Query Analyser



jbtaylor16 NO[at]SPAM fuse.net
10/14/2005 8:42:44 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
10/14/2005 9:42:41 PM
(jbtaylor16@fuse.net) writes:
[quoted text, click to view]

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
AddThis Social Bookmark Button