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.
与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
