IF (NOT EXISTS (SELECT * 
                 FROM INFORMATION_SCHEMA.TABLES 
                 WHERE TABLE_SCHEMA = 'dbo' 
                 AND  TABLE_NAME = 'Table1'))
BEGIN

CREATE TABLE Table1
(
     ProductID int,
     ProductName varchar(1000),
     Quantity int
)


INSERT INTO Table1(ProductID,ProductName,Quantity) VALUES (1,'Table',100)

INSERT INTO Table1(ProductID,ProductName,Quantity) VALUES (2,'Chairs',200)

INSERT INTO Table1(ProductID,ProductName,Quantity) VALUES (3,'Printer',300)

END