Table: SalesPersonQuotaHistory

Properties

Property	Value
Name	SalesPersonQuotaHistory
ID	1490104349
Owner	dbo
Schema	Sales
Filegroup	PRIMARY
Data Size (KB)	16 KB
Index Size (KB)	32 KB
Rows	163
Unused (KB)	0 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:52 PM

Extended Properties

Name	Value
MS_Description	Sales performance tracking.

Columns

Column ID	Column Name	Datatype
1	BusinessEntityID	int
2	QuotaDate	datetime
3	SalesQuota	money
4	rowguid	uniqueidentifier
5	ModifiedDate	datetime

Identity Columns

No identity columns defined.

Primary Key Constraints

Name	Is System Named	Extended Property Name	Extended Property Value
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate		MS_Description	Primary key (clustered) constraint

Primary Key Columns

Name
BusinessEntityID
QuotaDate

Foreign Keys

Name	Referenced Object	Update Action	Delete Action
FK_SalesPersonQuotaHistory_SalesPerson_BusinessEntityID	Sales.SalesPerson	No action	No action

Column Level Check Constraints

Name	Column ID	Column	Definition	Is Disabled	Is Not For Replication	Is Not Trusted	Uses Database Collation	Is System Named
CK_SalesPersonQuotaHistory_SalesQuota	3	SalesQuota	([SalesQuota]>(0.00))

Table Level Check Constraints

No table constraints defined.

Default Constraints

Name	Column	Definition	Is System Named	Extended Property Name	Extended Property Value
DF_SalesPersonQuotaHistory_rowguid	rowguid	(newid())		MS_Description	Default constraint value of NEWID()
DF_SalesPersonQuotaHistory_ModifiedDate	ModifiedDate	(getdate())		MS_Description	Default constraint value of GETDATE()

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
PK_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate	CLUSTERED
AK_SalesPersonQuotaHistory_rowguid	NONCLUSTERED

FullText Indexes

No fulltext indexes defined.

Referencing Tables

No referencing tables defined.

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_SalesPersonQuotaHistory_BusinessEntityID_QuotaDate	Aug 8 2010 5:23PM	163	163	11	0.1	12			163

Detailed Statistics Density

All Density	Average Length	Columns
0.05882353	4	BusinessEntityID
0.006134969	12	BusinessEntityID, QuotaDate

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
274	0	12	0	1
276	12	12	1	12
278	12	12	1	12
280	12	12	1	12
282	12	12	1	12
283	0	12	0	1
284	0	7	0	1
286	4	4	1	4
287	0	8	0	1
288	0	4	0	1
290	8	8	1	8

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
AK_SalesPersonQuotaHistory_rowguid	Aug 8 2010 5:23PM	163	163	144	1	28			163

Detailed Statistics Density

All Density	Average Length	Columns
0.006134969	16	rowguid
0.006134969	20	rowguid, BusinessEntityID
0.006134969	28	rowguid, BusinessEntityID, QuotaDate

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
ab87ae3a-a0db-4073-b348-02851be80d64	0	1	0	1
738ac57f-d7a4-42f6-bb6c-0447d877aa13	0	1	0	1
dfd01444-8900-461c-8d6f-04598dae01d4	0	1	0	1
b1382489-b7ef-465f-bc96-06fd27e8f320	0	1	0	1
aa3c8a00-6590-497e-80f6-075bb947e025	0	1	0	1
12aac834-ab2f-4e84-b85d-08839670c198	0	1	0	1
876e5dd7-de44-4497-bb38-08b1d56a9f5d	0	1	0	1
3e7198aa-2bf8-4050-9050-091d14f61ff1	0	1	0	1
10c5e693-5182-4951-9f36-0bae17b3878c	0	1	0	1
16962d2d-f610-4150-9c05-0be2e0ffe207	0	1	0	1
58e9567d-5174-4a27-a95a-11da6e6dc585	2	1	2	1
1290b655-35f4-4447-a4c5-1385f62fef4d	0	1	0	1
53a0df58-8b98-4371-97a5-14c1442a3582	0	1	0	1
b762b64b-0e51-41c9-889f-1535bf553bed	0	1	0	1
bb8c5bb9-475d-438b-a611-17a20f4a6b91	0	1	0	1
90489216-ea7e-43b0-be90-17f2ed47f2e2	0	1	0	1
c35fb2f4-1e84-4b8f-af6b-186315ccac08	0	1	0	1
c88dafc0-a293-4a00-98c2-1a530288a113	0	1	0	1
0e252d7f-f0a3-493a-93ff-1aca0fbfe0ad	0	1	0	1
d44e0e60-c00c-413b-b288-1b69553120bc	0	1	0	1
1ea57383-0be7-46e8-bfb9-21034fabe6cc	1	1	1	1
9aeda6ba-4476-4f8e-821b-26b52596718f	0	1	0	1
ce0b49c6-ced2-46b2-83c4-28f72d04ce5c	0	1	0	1
0cfb6474-20aa-46d3-a5c0-29dba2eda025	0	1	0	1
87ac1fb7-a3c5-43a6-90aa-2d09ae00148a	1	1	1	1
496e25d7-21a1-4185-9fbc-2db261c8de25	0	1	0	1
816a0650-905e-4079-8f89-2e1a698a1e10	0	1	0	1
fcef2af1-6183-41b3-a04f-2ead88389267	0	1	0	1
f72567da-8a78-43c7-9adb-30b1503e6f56	0	1	0	1
4b6ebe93-65ed-474b-9210-3115f0979546	0	1	0	1
59e16b51-71f7-48e4-8a80-359103fe685a	0	1	0	1
08270720-0537-4f0e-ba15-375ec0660f31	0	1	0	1
a0018050-d5a1-46b9-88a0-37ea2034585a	0	1	0	1
c81757ca-da32-4618-8429-395f96283a6d	0	1	0	1
ba494ea7-5ced-4044-995c-39a69dd68b34	0	1	0	1
634a330e-8683-42d4-824f-39b3f9076270	0	1	0	1
81ef8bc1-eff8-4cff-adc3-3b76104d9b5f	0	1	0	1
b9c12814-44b8-47ce-8db8-45a7c91e360b	0	1	0	1
5fbe0fbe-45ff-42ad-9e04-46d6c5dd24a9	0	1	0	1
f22dfa8f-2d6d-4ca1-9abf-48d8b2b4f705	0	1	0	1
d3afa546-5a53-47ca-b2ac-49a54d68c090	0	1	0	1
a6cf1e2a-da84-407a-9bec-4ad473708c0b	0	1	0	1
87a51a0f-3d6d-42d0-98a7-4ad934977417	0	1	0	1
bff32188-2095-43b6-88ff-4cdcdd7c2f4c	0	1	0	1
1b62e37f-2045-404a-b3f0-4e7b65c8d979	0	1	0	1
2c00a4fc-8f81-4b01-8e12-5171e008803b	0	1	0	1
76d1ed81-97a0-466e-8778-51b19e6b21fa	0	1	0	1
27ded788-f295-472a-8151-5254a86103e0	0	1	0	1
5db4299a-1ad9-49c6-b024-528c771cae3f	0	1	0	1
c637e5f0-1e12-41f6-932e-53714b6961a8	0	1	0	1
d1f92ec2-0c55-47d4-be71-54b37223d19f	0	1	0	1
440aa05d-4bc7-4093-8c4e-54f7f8c74bb9	0	1	0	1
40ade5de-6cae-40c2-8d7f-594045a6a40e	0	1	0	1
62dd856a-7b26-4952-861d-5c8b85a2e859	0	1	0	1
5671ec9e-4fa4-4232-907f-5cb981445e52	0	1	0	1
a6b9418a-d891-469e-a2c2-5d3e8e7251fd	0	1	0	1
6206c73d-958d-44ca-b1c1-5e0c34a3c156	0	1	0	1
62ce3158-2b10-483f-beb3-5e4d60966183	0	1	0	1
f8443072-c5b3-4f3f-8e20-5f53c90b0414	0	1	0	1
e7f639ac-53c3-4b66-8ecd-5f71e7cacb99	0	1	0	1
99109bbf-8693-4587-bc23-6036ec89e1be	0	1	0	1
68082afc-9a96-4ede-8b8e-64c4e9f8ddd4	0	1	0	1
20819180-2de9-41fe-9efb-6513453d69a0	0	1	0	1
9058a255-7745-494b-9a4b-6cea2d0a3ba7	0	1	0	1
cfa3347d-bbf9-4f9b-8339-6fc0fd0079f4	0	1	0	1
2df41dd8-182e-4c57-ae81-718f714cb4ff	1	1	1	1
bde90d55-c92e-4b0d-8e0c-72fd0eece610	0	1	0	1
760cef84-b980-417b-a667-7358c38857f0	0	1	0	1
a5ccd7a0-f696-489e-8d9b-73904d898dc6	0	1	0	1
59fd606c-22ff-4f43-951b-74fca7758ede	0	1	0	1
472859c3-39a7-4504-a0cd-760cbeac95f8	1	1	1	1
f9823592-5888-487d-9b86-79074a27a96f	0	1	0	1
aa12de6f-c835-4876-9afb-7ae5501db57e	0	1	0	1
00f2f9f8-5158-4436-b134-7e0c462289e5	0	1	0	1
122081ea-60af-45e8-b732-7e614edf8460	0	1	0	1
7a09cd71-eed6-485b-8af4-800c82aec15a	0	1	0	1
0103899f-618c-4478-90bb-815b20856f35	0	1	0	1
70785e05-776d-4479-b6b5-83d9b1c9d7dd	0	1	0	1
8b4e3cbf-f0ef-49c5-9a8c-87679055057e	0	1	0	1
03a84ecc-e299-4b61-a634-892399e0a0ec	1	1	1	1
cb65848e-16d8-42fd-a9f3-8a8cae4ceb9c	0	1	0	1
5e45eb9d-6592-444c-bb43-8b260afabd7d	0	1	0	1
a3974eb0-509f-432a-8046-8e14bb175a91	0	1	0	1
0569df99-deab-46ce-8818-8eee2dd47bf1	0	1	0	1
da8d1458-5fb9-4c3e-9ead-8f5ce1393047	0	1	0	1
c7a90e1b-3b08-4b58-84f7-8f70c9092d86	0	1	0	1
5f7e9647-3f08-49b0-a4a4-90257fc78197	0	1	0	1
d368dc2c-f142-48f6-a787-91d818c04534	0	1	0	1
eca1e739-05f5-4584-9118-927634284e93	0	1	0	1
173ad1f3-c953-4182-8168-97190ca5f929	0	1	0	1
23dcfb7a-4b3f-4302-b88a-989b28c9c32a	0	1	0	1
0f4f65ca-3a56-46f0-b5f0-9d86db593ca3	1	1	1	1
982237b6-4533-4dcb-907a-9e15d45afa59	0	1	0	1
9b6e418d-0842-4fe3-b86a-9eca7cce4367	0	1	0	1
cb4de112-c5fa-4b67-8eeb-9f09569c249c	0	1	0	1
eb5d735c-8bbd-4b6c-a7eb-a006335a5d2e	0	1	0	1
99552f0a-6a94-4a5b-afe9-a18973958b9e	0	1	0	1
34b585ba-dd7e-41e6-af29-a4ac61eae320	0	1	0	1
0a25496d-5797-44f6-9331-a71d06b0fd63	0	1	0	1
b06507b8-6a96-4819-ac31-a77411c9b777	0	1	0	1
bc1a222f-47a0-48d1-9c56-ac873269dc98	0	1	0	1
c5a85488-c1dc-4f85-9b24-addf853793f8	0	1	0	1
64c8e4f4-f979-4816-a2ee-b044ad74224d	0	1	0	1
8de8217f-553d-4614-b0e0-b0bdb32e7aec	1	1	1	1
e9de95e3-b119-4441-bd1d-b27fc4516022	0	1	0	1
95b4b50b-08e7-4b71-a68c-b55f9400395b	0	1	0	1
1f07008f-826f-4c83-a3f6-b72ea3a406af	0	1	0	1
480c5a5b-e2ac-4c72-930b-b80e770fb14b	0	1	0	1
f9488f84-7dfe-4073-8de4-ba2ba1f3a00f	0	1	0	1
fceb753b-9a73-445a-937f-ba7ec99385b4	0	1	0	1
15e5eae2-bd36-4798-a066-bc7594e2930b	1	1	1	1
d566e989-d212-4b08-bb20-be7967ecefaf	2	1	2	1
61407c3a-731d-4269-9894-bfa0f447fe79	0	1	0	1
ee81e30a-0878-4fdd-b626-c44ad7b7df61	0	1	0	1
c69b67db-f35f-4dad-a8a8-c4d074ad17db	0	1	0	1
0a69f453-9689-4ccf-a08c-c644670f5668	0	1	0	1
5690e967-970d-41f6-9864-c64bd61a896d	0	1	0	1
070f2190-c4fb-4261-98ef-c6b5ca745de8	0	1	0	1
610f84c0-206d-487f-988e-c804abfc11a5	0	1	0	1
f436e58a-b6e5-4945-bee1-c80602b7b7a8	0	1	0	1
c40ac76f-5027-4417-9b60-cb1210ac079a	1	1	1	1
f020801a-4e65-42e3-83e5-cb92fde0beee	1	1	1	1
3bd5fb9e-0d3c-41b5-a619-cb98d6e5b7fe	0	1	0	1
13947d2c-a254-47c9-8817-cbd186ffa526	0	1	0	1
292d397c-b094-44bd-8374-cff90cf4b10a	0	1	0	1
bfb04c57-f0f4-4422-aa9b-d2a74e67a3a8	0	1	0	1
d1cf9bfc-0e82-4b0a-becc-da6246767a74	0	1	0	1
0323d0bc-c5cc-4d67-8935-dd05074fba43	0	1	0	1
15be4c16-782c-40fd-861f-dd85cdebca83	0	1	0	1
aeda3a74-5e52-4fdc-ae81-e236b4d14f5f	1	1	1	1
f6c65525-b30a-42b5-be6c-ea63b6bef320	0	1	0	1
4f97c4d6-9c4c-4915-9ca4-eab679d373f6	0	1	0	1
118f1fc6-7b7e-4588-90b0-f08ba349dbe7	0	1	0	1
adc65c86-afee-4a07-80d9-f23039954c4a	1	1	1	1
5af006c1-aa62-4303-875f-f248b448297c	0	1	0	1
85cd56a2-f1a1-4e1d-9ab6-f415d811f3c1	0	1	0	1
a2b99573-af8a-461a-b554-f489de2fa266	0	1	0	1
d2fe8c53-8307-4c36-9571-f5648da24ca2	0	1	0	1
ad3e7040-3f1f-485e-a716-f7d18ce09e76	2	1	2	1
375ed681-8543-49e2-bb95-fa56545568e8	0	1	0	1
4580482f-a91e-4482-a95d-fc7bce1a2e01	1	1	1	1
e35d6a3a-8303-47dd-b0e6-fd7d40a396b2	0	1	0	1
c97c50f2-2dbe-465d-8780-fe201f0cfd25	0	1	0	1
7cea47b5-8391-4414-a866-ff6ec6628cd3	0	1	0	1

Objects that depend on [SalesPersonQuotaHistory]

Sales.SalesPersonQuotaHistory

Objects on which [SalesPersonQuotaHistory] depends

Sales.SalesPersonQuotaHistory
- Sales.SalesPerson
  - Sales.SalesTerritory
    - Person.CountryRegion
      - dbo.Name
  - HumanResources.Employee
    - Person.Person
      - Person.AdditionalContactInfoSchemaCollection
      - Person.BusinessEntity
      - Demographics.exist
      - Person.IndividualSurveySchemaCollection
      - dbo.NameStyle
    - dbo.Flag

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[SalesPersonQuotaHistory]( [BusinessEntityID] [int] NOT NULL, [QuotaDate] [datetime] NOT NULL, [SalesQuota] [money] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales person identification number. Foreign key to SalesPerson.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'BusinessEntityID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales quota date.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'QuotaDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales quota amount.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'SalesQuota' 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'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @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'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales performance tracking.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory'

Script

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[SalesPersonQuotaHistory]( [BusinessEntityID] [int] NOT NULL, [QuotaDate] [datetime] NOT NULL, [SalesQuota] [money] NOT NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales person identification number. Foreign key to SalesPerson.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'BusinessEntityID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales quota date.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'QuotaDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales quota amount.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'SalesQuota'
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'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @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'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales performance tracking.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesPersonQuotaHistory'

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
274	0	12	0	1
276	12	12	1	12
278	12	12	1	12
280	12	12	1	12
282	12	12	1	12
283	0	12	0	1
284	0	7	0	1
286	4	4	1	4
287	0	8	0	1
288	0	4	0	1
290	8	8	1	8

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
274	0	12	0	1
276	12	12	1	12
278	12	12	1	12
280	12	12	1	12
282	12	12	1	12
283	0	12	0	1
284	0	7	0	1
286	4	4	1	4
287	0	8	0	1
288	0	4	0	1
290	8	8	1	8

Table: SalesPersonQuotaHistory

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 [SalesPersonQuotaHistory]

Objects on which [SalesPersonQuotaHistory] depends

SQL

See also

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
274	0	12	0	1
276	12	12	1	12
278	12	12	1	12
280	12	12	1	12
282	12	12	1	12
283	0	12	0	1
284	0	7	0	1
286	4	4	1	4
287	0	8	0	1
288	0	4	0	1
290	8	8	1	8