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. |
See Also