DEFAULT on column Bonus|((0.0))
DEFAULT on column CommissionPct|((0.0))
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
DEFAULT on column SalesLastYear|((0.0))
DEFAULT on column SalesYTD|((0.0))
FOREIGN KEY|SalesPersonID
|REFERENCES AdventureWorks.HumanResources.Employee (EmployeeID)
FOREIGN KEY|TerritoryID
|REFERENCES AdventureWorks.Sales.SalesTerritory (TerritoryID)
PRIMARY KEY (clustered)|SalesPersonID