Person.ContactType

Table: 'Person.ContactType'

3 fields. 120 bytes.

Lookup table containing the types of contacts stored in Contact.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ContactTypeIDint identity int Not nullPrimary key for ContactType records. 
NameName nvarchar(50) Not nullContact type description. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Person.ContactType'

Primary Key NameField Name
PK_ContactType_ContactTypeIDContactTypeID
There are no Foreign Keys for this table.

Indexes for table 'Person.ContactType', 2 items

Index NameDescriptionClusteredUniqueFields
PK_ContactType_ContactTypeIDClustered index created by a primary key constraint.YesYesContactTypeID
AK_ContactType_NameUnique nonclustered index.NoYesName

Triggers for table 'Person.ContactType', 1 item

NameDescriptionTypeEnabled
uContactTypeAFTER UPDATE trigger setting the ModifiedDate column in the ContactType table to the current date.after Update Yes

Dependencies for table 'Person.ContactType', 4 items

Object NameTypeField Name
dbo.ufnGetContactInformationtable functionN/A
Person.uContactTypetriggerN/A
Purchasing.vVendorviewN/A
Sales.vStoreWithDemographicsviewN/A