This documentation is archived and is not being maintained.

ContactType Table (AdventureWorks)

Contains the types of contacts (customer or vendor) stored in the Contact table. For example, customer contact types might be Purchasing Manager or Purchasing Agent, and vendor contact types might be Sales Manager or Sales Representative.

The ContactType table is contained in the Person schema.

Column Data type Nullability Description

ContactTypeID

int

Not null

Primary key for ContactType records.

Name

Name (user-defined type)

nvarchar(50)

Not null

Contact type description.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

Show: