|  | Posted by jbtaylor16 on 10/14/05 18:42 
I have several default constraints defined on a table.  When I use theObject 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
  Navigation: [Reply to this message] |