[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 842
  • Last Modified:

What is Schema Binding in SQL Server?

Hi All,
What is Schema Binding,How is it useful in SQL Server?
0
saratcm
Asked:
saratcm
2 Solutions
 
Om PrakashCommented:
SCHEMA BINDING is commonly used with SQL Server objects like views and User Defined Functions (UDF). The main benefit of SCHEMA BINDING is to avoid any accidental drop or change of an object that is referenced by other objects. A User Defined Function (UDF) may or may not access any underlying database objects, but in this tip we show how using SCHEMA BINDING with a UDF can improve performance even if there are no underlying objects.

Example:
http://www.mssqltips.com/tip.asp?tip=1692
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
SCHEMABINDING is done in VIEWS to bind the view to the schema.
While doing so, you can also create INDEXED views for better performance.
http://msdn.microsoft.com/en-us/library/cc917715.aspx

When SCHEMABINDING is specified, the select_statement must include the two-part names (owner.object) of tables, views, or user-defined functions referenced.

Views or tables participating in a view created with the schema binding clause cannot be dropped unless that view is dropped or changed so that it no longer has schema binding. Otherwise, SQL Server raises an error. In addition, ALTER TABLE statements on tables that participate in views having schema binding will fail if these statements affect the view definition.
0
 
saratcmAuthor Commented:
Good
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now