Search code examples
sql-server-2008adventureworks

AdventureWorks 2008--where to find Customer names

I'm using the AdventureWorks 2008 sample database to do some testing and teaching. The Sales.Customer table is linked to the Sales.SalesOrderHeader table, as I'd expect, but I can't figure out where the rest of the Customer data (like Name) is stored.

When I poke around for documentation, it refers to a Sales.Individual table, but I don't see that one.

Not sure it matters, but I'm using SQL Server 2008 R2.

Solution

  • Sales.Customer (PersonID) is a foreign key to Person.Person (BusinessEntityID). You'll find the related data in the Person.* tables.