Person.ContactType

Field Name Data Type Size Original Type Default Nullable Description Check

ContactTypeID int identity int Not null Primary key for ContactType records.

Name Name nvarchar(50) Not null Contact type description.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Original Type	Default	Nullable	Description
ContactTypeID	int identity	int		Not null	Primary key for ContactType records.
Name	Name	nvarchar(50)		Not null	Contact type description.
ModifiedDate	datetime		getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Person.ContactType'

Primary Key Name Field Name

PK_ContactType_ContactTypeID ContactTypeID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_ContactType_ContactTypeID	ContactTypeID

Indexes for table 'Person.ContactType', 2 items

Index Name Description Clustered Unique Fields

PK_ContactType_ContactTypeID Clustered index created by a primary key constraint. Yes Yes ContactTypeID

AK_ContactType_Name Unique nonclustered index. No Yes Name

Index Name	Description	Clustered	Unique	Fields
PK_ContactType_ContactTypeID	Clustered index created by a primary key constraint.	Yes	Yes	ContactTypeID
AK_ContactType_Name	Unique nonclustered index.	No	Yes	Name

Triggers for table 'Person.ContactType', 1 item

Name Description Type Enabled

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

Name	Description	Type	Enabled
uContactType	AFTER 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 Name Type Field Name

dbo.ufnGetContactInformation table function N/A

Person.uContactType trigger N/A

Purchasing.vVendor view N/A

Sales.vStoreWithDemographics view N/A