Generated using SQL Data Dictionary demo version.
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. | |||||
Primary key (clustered) constraint
Unique nonclustered index.