Department Table (AdventureWorks)
Contains the departments within the Adventure Works Cycles company.
Department Table Definition
The Department table is contained in the HumanResources schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
DepartmentID |
smallint |
Not null |
Primary key for Department rows. |
Name |
Name (user-defined type) nvarchar(50) |
Not null |
Name of the department. |
GroupName |
Name (user-defined type) nvarchar(50) |
Not null |
Name of the group to which the department belongs. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Employee Table (AdventureWorks)
EmployeeDepartmentHistory Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary