>IF EXISTS(...)
>   DROP TABLE ArchiveRetrieval
>GO
>

IF object_id('ArchiveRetrieval') IS NOT NULL
...