Schema.Object has an unresolved reference to Schema

If while building a database project face this error:

Severity Code Description Project File Line Suppression State
Error SQL71501: Function: [schema].[object] has an unresolved reference to Schema [schema]. DBProject.Database D:\TFS\path\DBProject.Database\schema\Functions\schema.object.sql


Then this error might be because you have object definition referring to the schema under which they are supposed to be created but there is not script to create that schema. Suppose your schema name is empschema then you should add file smpschema.sql to the project with following code:

CREATE SCHEMA empschema AUTHORIZATION dbo;

Comments

Make Money from Surveys

Popular posts from this blog

The current master key cannot be decrypted

Remove dateModified related warning appearing during Structured data testing