Create Table SQL

Create Table Sale
(
   SaleID int identity(1,1) primary key,
   SaleDate Datetime default current_timestamp,
   CustomerID int Foreign key
       references Customer(CustomerID)
   --price decimal(6,2) not null
)