Create code for Sales.SalesOrderHeaderBig is

USE AdventureWorks2012Big
GO
CREATE TABLE Sales.SalesOrderHeaderBig(
 SalesOrderID int IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
 RevisionNumber tinyint NOT NULL,
 OrderDate datetime NOT NULL,
 DueDate datetime NOT NULL,
 ShipDate datetime NULL,
 [Status] tinyint NOT NULL,
 OnlineOrderFlag dbo.Flag NOT NULL,
 SalesOrderNumber  AS (isnull(N'SO'+CONVERT(nvarchar(23),SalesOrderID,(0)),N'*** ERROR ***')),
 PurchaseOrderNumber dbo.OrderNumber NULL,
 AccountNumber dbo.AccountNumber NULL,
 CustomerID int NOT NULL,
 SalesPersonID int NULL,
 TerritoryID int NULL,
 BillToAddressID int NOT NULL,
 ShipToAddressID int NOT NULL,
 ShipMethodID int NOT NULL,
 CreditCardID int NULL,
 CreditCardApprovalCode varchar(15) NULL,
 CurrencyRateID int NULL,
 SubTotal money NOT NULL,
 TaxAmt money NOT NULL,
 Freight money NOT NULL,
 TotalDue  AS (isnull((SubTotal+TaxAmt)+Freight,(0))),
 Comment nvarchar(128) NULL,
 rowguid uniqueidentifier ROWGUIDCOL  NOT NULL,
 ModifiedDate datetime NOT NULL,
 CONSTRAINT PK_SalesOrderHeaderBig_SalesOrderID PRIMARY KEY CLUSTERED
 (SalesOrderID ASC));
GO

CREATE UNIQUE NONCLUSTERED INDEX AK_SalesOrderHeaderBig_rowguid ON Sales.SalesOrderHeaderBig
 (rowguid ASC)
GO
CREATE UNIQUE NONCLUSTERED INDEX AK_SalesOrderHeaderBig_SalesOrderNumber ON Sales.SalesOrderHeaderBig
 (SalesOrderNumber ASC)
GO
CREATE NONCLUSTERED INDEX IX_SalesOrderHeaderBig_CustomerID ON Sales.SalesOrderHeaderBig
 (CustomerID ASC)
GO
CREATE NONCLUSTERED INDEX IX_SalesOrderHeaderBig_OrderDate ON Sales.SalesOrderHeaderBig
 (OrderDate ASC)
GO
CREATE NONCLUSTERED INDEX IX_SalesOrderHeaderBig_SalesPersonID ON Sales.SalesOrderHeaderBig
 (SalesPersonID ASC)
GO