Monday, February 1, 2010

SCHEMABINDING option

SCHEMABINDING option is used to ensure that you can't drop dependent objects ,for example you have a function which run SELECT statement form Students table so when you try to drop the table you will get an error prevent you to drop the table unless you drop the objects first.


You can use this option with functions and views.

Let's see how we can use it:



No comments: