DDemoDB AdventureWorks OLTP
← All tables and views

AdventureWorks OLTP table

HumanResources.Department

Lookup table containing the departments within the Adventure Works Cycles company.

16rows

4 columns

Schema from the provider contract
ColumnTypeNullableKeyReferences
DepartmentIDINTEGERnoPK—
NameTEXTno——
GroupNameTEXTno——
ModifiedDateTEXTno——

Keys and unique indexes

Physical SQLite metadata

Primary key is declared above.

Additional unique keys

HumanResources_Department_AK_Department_NameName
1 unique index inspected
HumanResources_Department_AK_Department_NameNameCREATE UNIQUE INDEX "HumanResources_Department_AK_Department_Name" ON "HumanResources.Department" ("Name")

Data preview

Sample records

16 rows available
DepartmentIDNameGroupNameModifiedDate
1EngineeringResearch and Development2008-04-30 00:00:00.000
2Tool DesignResearch and Development2008-04-30 00:00:00.000
3SalesSales and Marketing2008-04-30 00:00:00.000
4MarketingSales and Marketing2008-04-30 00:00:00.000
5PurchasingInventory Management2008-04-30 00:00:00.000
6Research and DevelopmentResearch and Development2008-04-30 00:00:00.000
7ProductionManufacturing2008-04-30 00:00:00.000
8Production ControlManufacturing2008-04-30 00:00:00.000
Open complete JSON data →Download CSV ↓

Interactive explorer

Explore HumanResources.Department

Powered by DataTug