Schema name for table or view is not specified

It is recommended to always specify schema name.

Usually, performance is slightly better if you specify the schema because it speeds the search for the object, but in certain cases, you need versions of the same table or view to be different depending on the user role.

You can put different tables or views of the same name in different schemas. You then need to specify the table without the schema because sql server will then choose the stored procedure from the schema associated with the role of the user.

The Product Learning article describing the problems caused by procedures that lack schema-qualification (PE001), applies equally to tables and views.

Didn't find what you were looking for?