Cannot drop schema because it is being reference by object
<p>I've looked through dozens of posts regarding this error and they all have the same solution, drop all the objects referenced by the schema - but the object the error gives me does not exist.</p>

<p>So I try to run the following syntax</p>

<pre><code>DROP SCHEMA [Application]
</code></pre>

<p>And the error it gives is</p>

<pre><code>Cannot drop schema 'Application' because it is being referenced by object 'ApplicationRequestTable'.
</code></pre>

<p>So I think "ok no problem, I'll remove that object, just like the past couple of views it pointed out", so I type</p>

<pre><code>SELECT * FROM sys.objects WHERE name = N'ApplicationRequestTable'
</code></pre>

<p>And nothing is returned from the above - am I doing something wrong because it looks like my schema is referencing an object that does not exit?!?  I further verify by typing</p>

<pre><code>SELECT o.name, s.name FROM sys.objects o JOIN sys.schemas s on o.schema_id = s.schema_id ORDER by s.name
</code></pre>

<p>And there is not a single object under the Application schema...  Any pointers would be greatly appreciated as I cannot see anything at all referencing this schema now?</p>

<p>Version: SQL Server 2014 SP1 (build 12.0.4100)</p>