Generated using SQL Data Dictionary demo version.

Table HumanResources.Department (16 rows)

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

  Column Data Type Identity Nullable Default
PK DepartmentID smallint X
Primary key for Department records.
UK Name Name(nvarchar(50))
Name of the department.
GroupName Name(nvarchar(50))
Name of the group to which the department belongs.
ModifiedDate datetime getdate()
Date and time the record was last updated.


Referenced by:

Used by: