• I think what you want is something like:

    IF EXISTS(SELECT * FROM sys.tables WHERE name = 'Orders')
        SELECT *
        FROM Orders;