.png)
ContactType Table (AdventureWorks)
SQL Server 2005
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. |
Reference
Contact Table (AdventureWorks)StoreContact Table (AdventureWorks)
VendorContact Table (AdventureWorks)
