====== Microsoft - Microsoft SQL Server - SQL - Check Object Exists ======

<code sql>
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SomeTable$Some Doc]') AND type in (N'U'))
  UPDATE[SomeTable$Some Doc]
  SET ...
</code>

----

===== Alternatively =====

<code sql>
IF EXISTS (SELECT 1 FROM SomeTable WHERE Name = 'somename')
</code>