sql server - Cannot schema bind view MyName' because name MyTable is invalid for schema binding

Question

I am trying to create an indexed view in SQL Server 2012 on a query that has 10 joins (inner and left), which is accessed a lot.

However, when attempting to create the view, I get an error:

Cannot schema bind view 'vw_transaction' because name 'entity_event' is invalid for schema binding.

I am (attempting to) create the view using:

CREATE VIEW vw_transaction WITH SCHEMABINDING AS
    Select ee.id as entity_event_id,
        ....

Is there a reason for this error? It looks like it's a reserved word, as the error mentions a 'name', as opposed to a column. Entity_event is the name of my main table.

question from:https://stackoverflow.com/questions/24226584/cannot-schema-bind-view-myname-because-name-mytable-is-invalid-for-schema-bindi

Answer 1

I fixed the issue by adding the schema name in front of all table references:

select [..] from schema_name.table_name