sql server - What is SCHEMABINDING? And for what purpose we use it?

Question

What is SCHEMABINDING? And for what purpose we use it?

Answer 1

Using WITH SCHEMABINDING indicates that the underlying table the view is referencing cannot have its schema changed. They are 'bound' together in essence.

The reason this is important is because SQL Server does not need to check periodically to see whether or not the schema has changed. This speeds up the performance of views, and is required for Indexed Views.

ask.sqlservercentral.com has more detail.