Wrath Of A God (2)

BEGIN TRANSACTION;

-- Table creation with multiple issues

CREATE TABLE Orders (

 OrderID INT PRIMARY KEY NOT NULL, 

 CustomerID INT NOT NULL,

 OrderDate DATETIME DEFAULT GETDATE(),

 TotalAmount DECIMAL(10, 2) NOT NULL,

 ShippedDate DATETIME DEFAULT NULL

);

-- This part introduces an incorrect foreign key constraint

ALTER TABLE Orders

BEGIN TRANSACTION;

-- Table creation with multiple issues

CREATE TABLE Orders (

 OrderID INT PRIMARY KEY NOT NULL, 

 CustomerID INT NOT NULL,

 OrderDate DATETIME DEFAULT GETDATE(),

 TotalAmount DECIMAL(10, 2) NOT NULL,

 ShippedDate DATETIME DEFAULT NULL

);

-- This part introduces an incorrect foreign key constraint

ALTER TABLE Orders

ADD CONSTRAINT FK_CustomerOrders

FOREIGN KEY (CustomerID)

REFERENCES Customers(CustomerID) -- Syntax issue: Missing closing parenthesis or extra comma