SQL: Check if table exists

1. By using the OBJECT_ID() function

If OBJECT_ID('my_table', 'U') is not null

BEGIN
    print 'my_table Table exists'
END

2. By using the INFORMATION_SCHEMA.TABLES

If exists (SELECT * FROM INFORMATION_SCHEMA.TABLES Where table_name = 'my_table')

BEGIN
    print 'my_table Table exists!'
END

3. By using sys.Objects Catalog view

If exists(Select * from sys.objects where  object_id = OBJECT_ID('my_table') and type = 'U')

BEGIN
    print 'my_table Table exists!'
END