Department Table (AdventureWorks)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

Department Table (AdventureWorks)

Contains the departments within the Adventure Works Cycles company.

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.

Show:
© 2016 Microsoft