TSD3012: The following dependencies are missing from your database project: {list}. Your database application might fail at runtime when {referencing object id} is executed.

  • Article

This warning occurs when an object definition references an object that is not contained in the database project. The database project is unable to determine whether the referenced object will exist after the referencing object is deployed.

To correct this warning

  • Verify whether the referenced object will exist when the referencing object is deployed. If the referenced object will exist, you can safely ignore this warning.

Example

The following example shows a stored procedure definition that references a table that is not defined in the database project. If the table is dynamically created, the procedure might be correct.

CREATE PROCEDURE proc1 
AS 
SELECT * FROM UndefinedTable; 
RETURN 0;

The procedure will deploy successfully, but it might fail when it is called if that referenced object does not exist.