Owner: HumanResources 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 24 
Rows: 16 
Description: Lookup table containing the departments within the Adventure Works Cycles company. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    DepartmentID  smallint          Primary key for Department records. 
    Name  Name  100          Name of the department. 
    GroupName  Name  100          Name of the group to which the department belongs. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 4 column(s)

Identity column

Name Seed Increment Not for replication


Index Primary Unique Description
  PK_Department_DepartmentID      Primary key (clustered) constraint 
  AK_Department_Name      Unique nonclustered index. 
Total: 2 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  HumanResources.EmployeeDepartmentHistory  FK_EmployeeDepartmentHistory_Department_DepartmentID  PK_Department_DepartmentID 
Total: 1 table(s)

Objects that [HumanResources].[Department] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
Total: 1 object(s)

Objects that depend on [HumanResources].[Department]

Object Name Owner Object Type Dep Level
  EmployeeDepartmentHistory  HumanResources  Table 
  vEmployeeDepartment  HumanResources  View 
  vEmployeeDepartmentHistory  HumanResources  View 
Total: 3 object(s)


CREATE TABLE [Department] (
    [DepartmentID] [smallint] IDENTITY (1, 1) NOT NULL ,
    [Name] [Name] NOT NULL ,
    [GroupName] [Name] NOT NULL ,
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Department_ModifiedDate] DEFAULT (getdate()),
    )  ON [PRIMARY]

See Also

List of tables