Use Atlantic;
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'usp_Create_Table_Orders') AND type = 'P')
DROP PROCEDURE dbo.usp_Create_Table_Orders
GO
CREATE PROCEDURE usp_Create_Table_Orders
AS
CREATE TABLE Orders
(
  orders_id INT NOT NULL
, customer_id	INT NOT NULL
, product_id INT NOT NULL
, destination_id INT NOT NULL
, orders_sell_price DECIMAL(6,2) NOT NULL CHECK (orders_sell_price > 0)
, orders_qty INT NOT NULL DEFAULT 1, CHECK (orders_qty > 0)
, orders_date DATE NOT NULL DEFAULT GETDATE()
, CONSTRAINT PK_Orders PRIMARY KEY CLUSTERED (orders_id)
);

