locked
Alter with relation with object that have "with schemabinding" RRS feed

  • Question

  • Hy,

    I have a db with undreds of objects Views , ufn etc... linked one wich other with "with schemabindig".

    If i try to alter definition of an object that have ralationship with other .... expecially if other object refer to it, is impossible to alter definition until i remove the reference.

    I i have hundreds of reference the work happen very big.

    There are a solution that automatically help me to change definiotion?

     

    thanks.


    Marco Bosco
    • Moved by Anca Popa Tuesday, March 15, 2011 8:48 AM English and not Italian (From:Microsoft SQL Server Forum)
    Tuesday, March 8, 2011 7:31 PM

Answers

  • The whole purpose of a view WITH SCHEMABINDING, is that objects it depends on cannot be changed.

    I don't know any "automatic" solution to that. And I think that was also the answer of others when this question was asked just a few days ago.

     


    Gert-Jan
    • Marked as answer by Kalman Toth Sunday, March 20, 2011 4:34 PM
    Tuesday, March 15, 2011 7:35 PM