Missing Primary key

nunz112

I made a script today from my dev to prod box and the primary key did not get made on prod which caused the foreign key constraints to fail, any idea why it would have missed it? it was creating the table on prod

Brian Donahue

Oh, any chance you have a filestream associated with that table? I think we may have an open bug about this already ( SC-5219 ).

nunz112

no filestreams

Brian Donahue

OK, I've raised a support call about this. We'll probably be asking you for the table scripts, etc.

jgonzalez

Did you have ignore indexes checked? Ignoring indexes also ignores the primary key.

nunz112

Yes I did but I would like it to create the primary key even in these instances especially when this is going to be the creation of the table.

jgonzalez

Then you have to uncheck the Ignore Indexes option. You can script it out with the primary key if you do that.