Post reply

question

  • October 18, 2014 at 11:29 pm

    #300248

    Hi There,

    I have a question, Changing from a required child to optional child is easier than changing from an optional child to a required child.

    is it true or false can any one explain why.

    Thanks

  • October 19, 2014 at 6:57 am

    #1753352

    So you mean a foreign key constraint that allows nulls versus one that does not? Yes, changing to not allowing null values could be more difficult because you'll have to ensure you have data in all cases before you can modify the table.

    But that's assuming I'm interpreting your question correctly.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply