Cannot schema bind view '' because name '' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.

When we create view with SCHEMABINDING it is necessary to specify the schema name in objects name of SELECT statement. If we will execute following query:

CREATE VIEW view_StuInfo WITH SCHEMABINDING

AS

SELECT Age,Name FROM Student

We will get error message:

Cannot schema bind view 'view_StuInfo' because name 'Student' is invalid for schema binding. Names must be in two-part format and an object cannot reference itself.

Solution:

CREATE VIEW view_StuInfo WITH SCHEMABINDING

AS

SELECT Age,Name FROM dbo.Student