AdventureWorks Database
Description
AdventureWorks 2014 Sample OLTP Database
Schemas
| Schema | Description |
|---|---|
| dbo | |
| HumanResources | Contains objects related to employees and departments. |
| Person | Contains objects related to names and addresses of customers, vendors, and employees |
| Production | Contains objects related to products, inventory, and manufacturing. |
| Purchasing | Contains objects related to vendors and purchase orders. |
| Sales | Contains objects related to customers, sales orders, and sales territories. |
Users
| User | Description |
|---|---|
| dbo | |
| guest | |
| INFORMATION_SCHEMA | |
| initialuser | |
| sys |
Roles
| Role | Description |
|---|---|
| db_accessadmin | |
| db_backupoperator | |
| db_datareader | |
| db_datawriter | |
| db_ddladmin | |
| db_denydatareader | |
| db_denydatawriter | |
| db_owner | |
| db_securityadmin | |
| public |
File Groups
| File Group | Description |
|---|---|
| PRIMARY |
Full Text Catalogs
| Full Text Catalog | Description |
|---|---|
| AW2014FullTextCatalog |