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
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	Delete Action	Update Action	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

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'

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'

Table: BusinessEntity

Properties

Extended Properties

Columns

Identity Columns

Primary Key Constraints

Primary Key Columns

Foreign Keys

Column Level Check Constraints

Table Level Check Constraints

Default Constraints

Indexes

FullText Indexes

Referencing Tables

Object Level Permissions

Column Level Permissions

Statistics

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Objects that depend on [BusinessEntity]

Objects on which [BusinessEntity] depends

SQL

See also