AdventureWorks 2016 Sample OLTP Database
| 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. |
| User | Description |
|---|---|
| dbo | |
| guest | |
| INFORMATION_SCHEMA | |
| sys |
| Role | Description |
|---|---|
| db_accessadmin | |
| db_backupoperator | |
| db_datareader | |
| db_datawriter | |
| db_ddladmin | |
| db_denydatareader | |
| db_denydatawriter | |
| db_owner | |
| db_securityadmin | |
| public |
| File Group | Description |
|---|---|
| PRIMARY |
| Full Text Catalog | Description |
|---|---|
| AW2016FullTextCatalog |