Share via


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.

ContactType Table Definition

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.