Export (0) Print
Expand All
Expand Minimize

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.

Community Additions

ADD
Show:
© 2014 Microsoft