Table: 'HumanResources.Department'

4 fields. 218 bytes.

Lookup table containing the departments within the Adventure Works Cycles company.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
DepartmentIDsmallint identity smallint Not nullPrimary key for Department records. 
NameName nvarchar(50) Not nullName of the department. 
GroupNameName nvarchar(50) Not nullName of the group to which the department belongs. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.Department'

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

Indexes for table 'HumanResources.Department', 2 items

Index NameDescriptionClusteredUniqueFields
PK_Department_DepartmentIDClustered index created by a primary key constraint.YesYesDepartmentID
AK_Department_NameUnique nonclustered index.NoYesName

Triggers for table 'HumanResources.Department', 1 item

uDepartmentAFTER UPDATE trigger setting the ModifiedDate column in the Department table to the current date.after Update Yes

Dependencies for table 'HumanResources.Department', 3 items

Object NameTypeField Name