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

Help and Information

Getting SQL Server 2005 Assistance