Object_id

OBJECT_ID

AlaSQL emulates TSQL OBJECT_ID() function:

IF OBJECT_ID('dbo.Parts') IS NOT NULL
  DROP TABLE dbo.Parts;
GO 

This functions can be used to check if table or view object is in the current database.