Old way of checking if item exists before drop

SQLDropIFExistsOld.sql

IF EXISTS(SELECT 1 FROM sys.objects AS O WHERE O.name = 'Product' AND O.[type] = 'U')
BEGIN
    DROP TABLE [SomeTable]
END
 

IF OBJECT_ID('dbo.Product', 'U') IS NOT NULL
BEGIN
   DROP TABLE dbo.Product;
END

IF EXISTS (SELECT * FROM sys.triggers WHERE name = 'trProductInsert')
BEGIN
  DROP TRIGGER trProductInsert
END