This is an old revision of the document!

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 ...

</sql>

Alternatively

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