schema binding

• pfernandez-851320

  SSC Veteran

  Points: 222

  More actions

  August 15, 2008 at 1:34 pm

  #75283

  Hello,

  I have seen WITH SCHEMA BINDING ina book I am reading on SQL server.

  Could anyone explain the significance of it and when/why I should use it

  Thanks

  Phil

• Richard Fryar

  Hall of Fame

  Points: 3457

  More actions

  August 16, 2008 at 5:19 pm

  #859135

  I presume you are reading about functions.

  The WITH SCHEMABINDING clause prevents the object(s) referenced by the function from being altered or dropped.

  This can also be used with the CREATE VIEW statement, and has the same effect. It is required for indexed views.

  
  Check Your SQL Servers Quickly and Easily
  www.sqlcopilot.com