Schema Binding With View in SQL Server

Question

I want to know why we use schema binding with view in SQL Server. Thank you.

Satyapriya Nayak · Answer

Hi Vipendra Please refer the below links http://strangenut.com/blogs/dacrowlah/archive/2008/12/02/what-does-schemabinding-mean-in-sql-2005-and-2008.aspx http://www.mssqltips.com/sqlservertip/1692/using-schema-binding-to-improve-sql-server-udf-performance/ Thanks