# Table: BusinessEntity

## Properties

Property | Value
--- | ---
Name | BusinessEntity
ID | 341576255
Owner | dbo
Schema | Person
Filegroup | PRIMARY
Data Size (KB) | 768 KB
Index Size (KB) | 512 KB
Rows | 20777
Unused (KB) | 144 KB
ANSI Null On |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space |
Filestream Data Space ID |
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
Modify Date | 8/8/2010 5:23:43 PM
Create Date | 8/8/2010 5:21:47 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Source of the ID that connects vendors, customers, and employees with address and contact information.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | BusinessEntityID | int |  |  |
2 | rowguid | uniqueidentifier |  |  |
3 | ModifiedDate | datetime |  |  |

## Identity Columns

Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | --- | --- | ---
BusinessEntityID | 1 | 1 | 20777 |  |  |  |

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_BusinessEntity_BusinessEntityID |  | MS_Description | Primary key (clustered) constraint

## Primary Key Columns

Name
BusinessEntityID

## Foreign Keys

No foreign keys defined.

## Column Level Check Constraints

No column constraints defined.

## Table Level Check Constraints

No table constraints defined.

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_BusinessEntity_rowguid | rowguid | (newid()) |  | MS_Description | Default constraint value of NEWID()
DF_BusinessEntity_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_BusinessEntity_BusinessEntityID | CLUSTERED |  |  |  |  |
AK_BusinessEntity_rowguid | NONCLUSTERED |  |  |  |  |

## FullText Indexes

No fulltext indexes defined.

## Referencing Tables

Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object
--- | --- | --- | --- | --- | --- | --- | --- | ---
FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID | 1 |  |  |  | No action | No action |  | Person.BusinessEntityAddress
FK_BusinessEntityContact_BusinessEntity_BusinessEntityID | 1 |  |  |  | No action | No action |  | Person.BusinessEntityContact
FK_Person_BusinessEntity_BusinessEntityID | 1 |  |  |  | No action | No action |  | Person.Person
FK_Store_BusinessEntity_BusinessEntityID | 1 |  |  |  | No action | No action |  | Sales.Store
FK_Vendor_BusinessEntity_BusinessEntityID | 1 |  |  |  | No action | No action |  | Purchasing.Vendor

## Object Level Permissions

No object level permissions defined.

## Column Level Permissions

No explicit column permissions granted to this object

## Statistics

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_BusinessEntity_BusinessEntityID | Aug 8 2010 5:22PM | 20777 | 20777 | 3 | 1 | 4 |  |  | 20777

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
4.813014E-05 | 4 | BusinessEntityID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
1 | 0 | 1 | 0 | 1
20776 | 20774 | 1 | 20774 | 1
20777 | 0 | 1 | 0 | 1

### Detailed Statistics General

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_BusinessEntity_rowguid | Aug 8 2010 5:23PM | 20777 | 20777 | 121 | 1 | 20 |  |  | 20777

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
4.813014E-05 | 16 | rowguid
4.813014E-05 | 20 | rowguid, BusinessEntityID

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
e03be89b-4712-428e-b088-00003ba63e22 | 0 | 1 | 0 | 1
88995e28-e219-4e3f-bf0e-02496d6c74d2 | 198 | 1 | 198 | 1
2cb088a2-5288-4f62-9b55-034629acefe6 | 63 | 1 | 63 | 1
652bc87a-d291-4411-9fb5-049e262723cc | 127 | 1 | 127 | 1
00021813-91ef-4a97-9682-0d2ac8c9ea97 | 671 | 1 | 671 | 1
1d5368a4-ec30-47aa-b3e2-0e30b23dad5a | 95 | 1 | 95 | 1
b9fca2fc-3838-4461-9c4b-10fc0be944ff | 191 | 1 | 191 | 1
55d17e15-3674-4027-b802-13139bfcd6b8 | 159 | 1 | 159 | 1
b7918ccb-3254-4b3e-b6bc-14860fa4f6c4 | 127 | 1 | 127 | 1
fc178d28-ca6d-4798-b01f-170b3f571216 | 191 | 1 | 191 | 1
86ed36a8-b76f-401e-91a8-17bbaa759757 | 63 | 1 | 63 | 1
3c503ae4-39c7-4f7a-9e99-1aa2ed11e1a0 | 255 | 1 | 255 | 1
1bf820e0-b785-46c0-9eec-1c7436a9baca | 127 | 1 | 127 | 1
44d1a51c-8a18-4c71-aac6-1e2eede8053a | 159 | 1 | 159 | 1
ad42991f-5958-4022-8ec6-22eef21749f8 | 383 | 1 | 383 | 1
9d79098c-4755-42e9-9ba8-25b511b30958 | 191 | 1 | 191 | 1
449e52a9-3ed2-4090-83c8-2722cda727ac | 127 | 1 | 127 | 1
092bdf61-afb9-4360-a89d-286adcfd2c89 | 95 | 1 | 95 | 1
036c5ad1-0b4a-4a78-bf07-2a2e59ab5e71 | 159 | 1 | 159 | 1
3e91e7d8-c095-4345-ab8b-2f6107206a97 | 415 | 1 | 415 | 1
55d4aa4b-d265-4331-81e1-30718b299fd0 | 95 | 1 | 95 | 1
2a6206c4-08ee-4522-b8fb-3161e9a74e13 | 63 | 1 | 63 | 1
76a36091-9d30-464c-81b6-371939877891 | 447 | 1 | 447 | 1
78d6ca59-5ffd-4a1b-8cbd-37bad444b719 | 63 | 1 | 63 | 1
d062b0b7-c480-4e72-aa83-38d1519c0a81 | 95 | 1 | 95 | 1
30b98c34-3c53-4361-bea2-397545e4dd61 | 63 | 1 | 63 | 1
83ece746-dd92-4340-998f-3b31a269b42d | 127 | 1 | 127 | 1
d6696510-aa07-46c9-a1e0-3bfbf5df0448 | 63 | 1 | 63 | 1
a5b553c0-cbd7-4ac4-a52e-3da70894425f | 159 | 1 | 159 | 1
7b93dcbe-6eda-4ba6-b3b1-3ee4d87a64d6 | 95 | 1 | 95 | 1
009119aa-ed76-4ee8-9946-3fee1c8c33b1 | 95 | 1 | 95 | 1
0cc92e98-ea3d-45a6-9d29-4191c78763b3 | 127 | 1 | 127 | 1
4c4ca922-2655-4541-8cf2-436507ef47f1 | 127 | 1 | 127 | 1
79ab48a5-fe4b-489b-824d-45ed82ff832c | 223 | 1 | 223 | 1
dd68bdc7-b1fa-4c6a-9238-46797f820ced | 63 | 1 | 63 | 1
1e1323e2-e306-4523-8189-479d8cc0305f | 95 | 1 | 95 | 1
09441ac7-b585-49a8-ae94-49b6dcea3873 | 159 | 1 | 159 | 1
8cbf587d-cb2e-4828-8f61-4b20c3979c41 | 95 | 1 | 95 | 1
09241355-fa71-487c-87b4-4bcfec86f17b | 63 | 1 | 63 | 1
8630259c-efbb-4189-80d8-4d5cec4e398a | 127 | 1 | 127 | 1
fb04afe8-523b-4833-952f-4f1a51e8bc95 | 127 | 1 | 127 | 1
e6062b78-da21-473a-bd90-523771a5e20d | 255 | 1 | 255 | 1
083479fa-dcf4-4097-83a7-543dbd3395e0 | 191 | 1 | 191 | 1
c68cfaae-9591-40b2-8bf6-551d142b0cf3 | 63 | 1 | 63 | 1
aeff2046-0981-4072-8c52-5a57fe37e250 | 447 | 1 | 447 | 1
94e95578-f00f-4317-b916-5bf0e14ab612 | 127 | 1 | 127 | 1
5530892f-dbdd-4834-a1a6-60388a6d57bb | 383 | 1 | 383 | 1
0d50fe0d-643e-43a3-9866-644ff02bf5a0 | 319 | 1 | 319 | 1
c8aa32bd-b7c4-46c5-a33d-6549d0c16e02 | 63 | 1 | 63 | 1
de978e79-dc8e-4e77-9632-6afd1b4e0c1e | 447 | 1 | 447 | 1
98d25ae1-7e8f-4b01-a085-6ba850ef3de6 | 63 | 1 | 63 | 1
a0e9b2af-7722-4643-a8c3-70fe2de38147 | 383 | 1 | 383 | 1
c62cb0a4-d8c4-44e6-beb3-7345bc1996db | 191 | 1 | 191 | 1
3ccbad18-923d-4612-b589-75bd8522490a | 191 | 1 | 191 | 1
dd6f8cd1-47a2-4829-87fb-7aa7c052a6b6 | 447 | 1 | 447 | 1
9dca196b-ee0e-4582-8e52-7d11fb06073e | 191 | 1 | 191 | 1
1177edf4-848f-4e60-8aa9-7ed556ea8727 | 127 | 1 | 127 | 1
f6df76a1-06eb-4801-a15b-804daa962619 | 127 | 1 | 127 | 1
6d360b09-255c-4761-870d-811c2042552c | 63 | 1 | 63 | 1
f4961c0c-a4c5-47fa-a01d-828923ab94fa | 127 | 1 | 127 | 1
dda0df30-9dd0-44fd-87cc-8362aafb6aae | 63 | 1 | 63 | 1
6ab007fb-48fc-420e-9dbe-855d337b4120 | 127 | 1 | 127 | 1
0b545672-1f21-4a7a-a69c-87f5ed6a6f76 | 191 | 1 | 191 | 1
b9d719bb-f14c-4bd6-89d4-895203e4b647 | 127 | 1 | 127 | 1
52fef573-6614-41f5-b067-8adeb04f3248 | 127 | 1 | 127 | 1
5c0e55a2-6298-4b7c-b512-8bca1a2506c7 | 63 | 1 | 63 | 1
411c21e3-35a6-4b0b-8f74-8d7152153931 | 127 | 1 | 127 | 1
51d5e1a7-4e05-4caa-be89-8e21184a06a9 | 63 | 1 | 63 | 1
f667462d-3ae5-426c-a2fe-8f9c2b80cd3d | 127 | 1 | 127 | 1
cb986d31-26b4-4a05-bb9a-908e2540d0c1 | 63 | 1 | 63 | 1
825ec992-9fc1-46e8-910e-920add8aa6fa | 127 | 1 | 127 | 1
4acd408c-a85d-4cab-9994-95b7730221de | 287 | 1 | 287 | 1
0d08c93b-b7d2-44f0-ae8d-96d68a962645 | 95 | 1 | 95 | 1
df5ebcb5-badb-4c34-be86-982cd19a7e5d | 95 | 1 | 95 | 1
1c76d946-0f01-4051-9215-9bbe10a5c96a | 287 | 1 | 287 | 1
546dc6bc-eebf-44c3-b535-9e431aa88d36 | 191 | 1 | 191 | 1
06192040-896a-4608-a3c3-9f4bb5d07e09 | 95 | 1 | 95 | 1
0dce47af-3c85-4bf9-ab7a-a218c02bb7d2 | 191 | 1 | 191 | 1
b5b680c2-1992-4505-8371-a3538d0dbc3b | 95 | 1 | 95 | 1
d8dc5863-b043-4a51-b54a-a4b9f05efef7 | 95 | 1 | 95 | 1
6616705a-00a5-4d89-a161-a5e2353694e6 | 95 | 1 | 95 | 1
0c58ef3b-f914-4782-8255-a74aef24ad63 | 95 | 1 | 95 | 1
cde19444-675d-4da1-b0bc-a88b7533f08f | 95 | 1 | 95 | 1
40d41e96-a144-4e85-b0ca-ae272afcefd3 | 479 | 1 | 479 | 1
781b0d94-95c3-4d78-b01a-af2f1528fe44 | 95 | 1 | 95 | 1
126588c2-87cb-4cb3-9524-b064b37874d8 | 95 | 1 | 95 | 1
cf8cdf85-27d1-4d27-903d-b1712ee89f5d | 95 | 1 | 95 | 1
20136402-b5ba-4468-ab6f-b44075b68682 | 223 | 1 | 223 | 1
3c38db37-7fdb-445f-8242-b5ae3551613a | 127 | 1 | 127 | 1
36c31ff1-7aed-4644-bdea-b757ff47d331 | 127 | 1 | 127 | 1
9aad7e39-4ca3-43e3-b3fb-ba409daf3d10 | 255 | 1 | 255 | 1
d8f38523-8895-4904-8f7d-bf513d4807b7 | 383 | 1 | 383 | 1
b7a69d95-7f6e-4927-958c-c0b864a8203d | 127 | 1 | 127 | 1
106e9d91-7b4f-4e9c-bd89-c25013f58a6c | 127 | 1 | 127 | 1
0f3fe8ba-77f3-4443-ace8-c41486de41f2 | 127 | 1 | 127 | 1
6288a8d2-bd9f-47de-8278-c57a8b14b01d | 127 | 1 | 127 | 1
9530e804-de4b-480e-93e9-c869d8b462aa | 255 | 1 | 255 | 1
4d5be8f8-05fe-4083-82a9-cd428bd975d4 | 383 | 1 | 383 | 1
8d64e4f5-e8dd-46fc-8166-d037856594d5 | 255 | 1 | 255 | 1
cb4f2bf9-4421-422b-bc8c-d1e75d6fad01 | 127 | 1 | 127 | 1
b084c8d5-b7df-4b7b-a523-d354ea98d470 | 127 | 1 | 127 | 1
e8c44938-7d8a-4633-bc23-d68f0dd9eb16 | 255 | 1 | 255 | 1
1ae0f043-a789-444a-9f41-d992742fcdb1 | 255 | 1 | 255 | 1
8fbc4d7f-b1d5-417a-9595-db515d06f7c3 | 127 | 1 | 127 | 1
246cf885-5301-41b6-8d9f-de2bb64ac6d2 | 255 | 1 | 255 | 1
f39e944b-fb97-4c76-8067-df7adc50e479 | 127 | 1 | 127 | 1
0f6b415e-e64c-4dda-8e60-e2897a2a58b1 | 255 | 1 | 255 | 1
97b462c5-6a39-46f8-bc4e-e44367e7cdb3 | 127 | 1 | 127 | 1
00baaba9-bb40-4b3d-83e2-e5c2576ff413 | 127 | 1 | 127 | 1
d2814493-d182-45e5-8985-e77814307c95 | 127 | 1 | 127 | 1
b47d3c1e-5059-4b74-a641-e8f5676ffd3d | 127 | 1 | 127 | 1
8f8c1e9c-1240-4c40-a92e-ea4948f2bc70 | 127 | 1 | 127 | 1
ecc3a65a-ba22-4675-b888-f24f8cb86bec | 639 | 1 | 639 | 1
0c2b7846-d5f3-4f37-8ff4-f4023e8dc3ef | 127 | 1 | 127 | 1
2c3e6a06-b23a-4893-a002-f5833a93bdd0 | 127 | 1 | 127 | 1
865fcd28-c6b8-46af-8e24-f74c1faac16f | 127 | 1 | 127 | 1
ac05d11e-e5d6-400b-90b0-f8a3e34a80fe | 127 | 1 | 127 | 1
c3b367ba-dd56-4a25-8137-fba7d9100bb1 | 255 | 1 | 255 | 1
c219993a-76fb-4d5a-8858-ff3e275feb59 | 255 | 1 | 255 | 1
2a22fd03-e6bb-4d26-abc7-fffab1eda00a | 63 | 1 | 63 | 1
df6878e2-975c-4159-956b-fffc062075dc | 0 | 1 | 0 | 1

## Objects that depend on [BusinessEntity]

- Person.BusinessEntity
  - Person.BusinessEntityAddress
    - HumanResources.vEmployee
    - Purchasing.vVendorWithAddresses
    - Sales.vIndividualCustomer
    - Sales.vSalesPerson
    - Sales.vStoreWithAddresses
  - Person.BusinessEntityContact
    - dbo.ufnGetContactInformation
    - Purchasing.vVendorWithContacts
    - Sales.vStoreWithContacts
  - Person.Person
    - dbo.uspGetEmployeeManagers
    - dbo.uspGetManagerEmployees
    - HumanResources.Employee
      - dbo.vMobiEmployee
        - dbo.uMobiEmployeeTrg
      - HumanResources.dEmployee
      - HumanResources.EmployeeDepartmentHistory
        - HumanResources.vEmployeeDepartment
        - HumanResources.vEmployeeDepartmentHistory
      - HumanResources.EmployeePayHistory
        - HumanResources.uspUpdateEmployeeHireInfo
      - HumanResources.JobCandidate
        - dbo.uspSearchCandidateResumes
        - HumanResources.vJobCandidate
        - HumanResources.vJobCandidateEducation
        - HumanResources.vJobCandidateEmployment
      - HumanResources.uspUpdateEmployeeLogin
      - HumanResources.uspUpdateEmployeePersonalInfo
      - Production.Document
        - Production.ProductDocument
      - Purchasing.PurchaseOrderHeader
        - Purchasing.PurchaseOrderDetail
          - Purchasing.iPurchaseOrderDetail
          - Purchasing.uPurchaseOrderDetail
        - Purchasing.uPurchaseOrderHeader
      - Sales.SalesPerson
        - Sales.SalesOrderHeader
          - Sales.SalesOrderDetail
            - Sales.iduSalesOrderDetail
            - Sales.ufn_SalesByStore
          - Sales.SalesOrderHeaderSalesReason
          - Sales.uSalesOrderHeader
          - Sales.vSalesPersonSalesByFiscalYears
        - Sales.SalesPersonQuotaHistory
        - Sales.SalesTerritoryHistory
        - Sales.Store
          - Sales.Customer
          - Sales.vStoreWithDemographics
    - Person.EmailAddress
    - Person.iuPerson
    - Person.Password
    - Person.PersonPhone
    - Person.vAdditionalContactInfo
    - Sales.PersonCreditCard
    - Sales.vPersonDemographics
  - Purchasing.Vendor
    - Purchasing.dVendor
    - Purchasing.ProductVendor

## Objects on which [BusinessEntity] depends

- Person.BusinessEntity

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Person].[BusinessEntity]( [BusinessEntityID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for all customers, vendors, and employees.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntity', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntity', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntity', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Source of the ID that connects vendors, customers, and employees with address and contact information.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'TABLE',@level1name=N'BusinessEntity'

#### See also

List of Tables