table icon Table: SpecialOfferProduct

Properties

Property Value
Name SpecialOfferProduct
ID 158623608
Owner dbo
Schema Sales
Filegroup PRIMARY
Data Size (KB) 24 KB
Index Size (KB) 64 KB
Rows 538
Unused (KB) 0 KB
ANSI Null On true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space
Filestream Data Space ID
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On false
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
Modify Date 8/8/2010 5:23:43 PM
Create Date 8/8/2010 5:21:53 PM

Extended Properties

Name Value
MS_Description Cross-reference table mapping products to special offer discounts.

Columns

Column ID Column Name Datatype Nullable Is Sparse Is Column Set
1 SpecialOfferID int false false false
2 ProductID int false false false
3 rowguid uniqueidentifier false false false
4 ModifiedDate datetime false false false

Identity Columns

No identity columns defined.

Primary Key Constraints

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

Primary Key Columns

Name
SpecialOfferID
ProductID

Foreign Keys

Name Referenced Object Update Action Delete Action
FK_SpecialOfferProduct_Product_ProductID Production.Product No action No action
FK_SpecialOfferProduct_SpecialOffer_SpecialOfferID Sales.SpecialOffer No action No action

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_SpecialOfferProduct_rowguid rowguid (newid()) false MS_Description Default constraint value of NEWID()
DF_SpecialOfferProduct_ModifiedDate ModifiedDate (getdate()) false MS_Description Default constraint value of GETDATE()

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
PK_SpecialOfferProduct_SpecialOfferID_ProductID CLUSTERED true true false false false
AK_SpecialOfferProduct_rowguid NONCLUSTERED false true false false false
IX_SpecialOfferProduct_ProductID NONCLUSTERED false false false false false

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_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID 1 false false false No action No action false Sales.SalesOrderDetail

Object Level Permissions

No object level permissions defined.

Column Level Permissions

No explicit column permissions granted to this object

Statistics

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_SpecialOfferProduct_SpecialOfferID_ProductID Aug 8 2010 5:23PM 538 538 13 0.2 8 false 538

Detailed Statistics Density

All Density Average Length Columns
0.06666667 4 SpecialOfferID
0.001858736 8 SpecialOfferID, ProductID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
1 0 295 0 1
2 0 111 0 1
3 0 55 0 1
4 0 17 0 1
5 0 2 0 1
7 0 8 0 1
8 0 3 0 1
9 0 1 0 1
11 3 3 1 3
12 0 12 0 1
13 0 10 0 1
14 0 4 0 1
16 7 7 1 7

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_SpecialOfferProduct_rowguid Aug 8 2010 5:23PM 538 538 189 1 24 false 538

Detailed Statistics Density

All Density Average Length Columns
0.001858736 16 rowguid
0.001858736 20 rowguid, SpecialOfferID
0.001858736 24 rowguid, SpecialOfferID, ProductID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
f8019958-409f-4e8f-ae4b-00136b6d75b5 0 1 0 1
5fa38631-f1d4-4b66-b93a-01e3141ddace 2 1 2 1
ce63a0fd-d375-4a30-8f2f-035dca1d1ae5 1 1 1 1
f111bb9d-a39b-4177-8703-042a98c58798 1 1 1 1
bb0f1748-3bff-4307-abf2-04b26faf3499 3 1 3 1
8077c273-d074-4a0e-82a4-052330bde1a2 1 1 1 1
40a9e94e-3cee-4f4c-a97c-0776d38abfd5 1 1 1 1
1ad68c9c-48a0-4826-9686-094890e282da 3 1 3 1
3d539d6c-dfbe-4839-adcb-09b1d4d9235a 1 1 1 1
c6e0259d-03c0-4dde-a667-0acc230c6cb5 1 1 1 1
229d2375-2d78-4c6a-806b-0b359716a9f8 1 1 1 1
f3414c43-cf20-4aeb-ad8e-0b7e6e682d1c 1 1 1 1
6d732238-b6e3-4141-ac3a-0d0375c64e12 1 1 1 1
3978d7bc-5b59-4fdc-a77e-0d53fa7e2ae6 1 1 1 1
b2084244-90a4-4908-bc45-0f4fe01e7e22 3 1 3 1
90a7f526-c1ea-41e4-9f96-130c94b08604 3 1 3 1
f324603b-4482-48a7-95a5-137d28f4c572 1 1 1 1
9b7d807d-db0e-4ce7-bd6e-1584bacba995 1 1 1 1
f30acd94-2563-4817-8dac-16452b145160 1 1 1 1
24a371bb-6730-4fa4-b2b9-16adec67395b 1 1 1 1
aa76a900-d7fd-4ee7-9c4c-1750ceedacef 1 1 1 1
416c7d99-588f-431a-8d22-1791e1130094 1 1 1 1
076d7ae6-6ab7-4928-8987-18337709af60 1 1 1 1
36ae12e0-4d4c-457d-ae97-18ba0475ec33 1 1 1 1
2397f96e-2a43-44cd-b992-1b367d3b25ad 1 1 1 1
76a77eda-af12-4d5f-a83f-1ba721afb513 3 1 3 1
fe70f9bc-b3f6-44b0-896f-1bdad5674b2a 1 1 1 1
443988c4-6852-4510-877f-1e12f4846ca4 3 1 3 1
c33c4beb-25e2-4c05-af57-1fe1fd3b713b 7 1 7 1
e51b726d-274a-4a27-85bc-2148d4219e92 3 1 3 1
80e1fabb-7b30-433c-a78a-2164407c9585 1 1 1 1
9ac4a238-d3fd-4f8b-a0ba-22874f2ee828 1 1 1 1
32aa7c9c-7b5b-4777-9e6f-25aec4830d63 3 1 3 1
f7e02a4e-aff6-4655-944e-25efd2880b37 1 1 1 1
f453d8b5-d7ce-484d-a3d1-2767ff9276c5 1 1 1 1
12460f83-1677-431a-b7cf-28a3a980b99f 1 1 1 1
4193fd04-f96b-4146-895c-292c969b468a 1 1 1 1
ae7d5732-ad18-42d8-85eb-2a9f3653bdca 1 1 1 1
005d8818-0e25-4770-9a86-2b05371a5a1b 1 1 1 1
0ea15696-e203-4627-b2f1-2b8d24b23116 1 1 1 1
33252f3c-cc82-41e7-8a5b-2d4f9595a7f1 1 1 1 1
d652d9ad-6d41-4526-8e3b-2e19ec9e2550 1 1 1 1
fe9976c4-2b12-4f73-995a-2f407810bc3d 1 1 1 1
acaa9e83-b670-4b6d-a826-30a76c4924e4 1 1 1 1
c32171e5-c9ab-41b7-9f33-30d246341a00 1 1 1 1
f19f943b-7bf6-4617-87d9-316cc4c9bab2 1 1 1 1
3d56f896-e3d6-4a21-b617-31c51490e94d 1 1 1 1
87af8a2a-02b8-4657-aa55-327b87685c5c 1 1 1 1
e4568488-03a5-467a-9836-32e47379e158 1 1 1 1
94f10037-9f1a-47e1-a490-332db0d30918 1 1 1 1
2d79385d-555c-4033-8083-3517d802f1a4 5 1 5 1
8b5d68b0-eb43-45d5-a062-368c9ed00dfd 3 1 3 1
d397760d-eacd-4f26-a03e-3ad2a84c7e56 7 1 7 1
c60fb28d-2431-481c-985e-3fea8119d705 3 1 3 1
400ee299-745c-4003-b59a-4142fc8ce0b1 3 1 3 1
4837f43b-931b-4cd1-8db9-43976c6bb66c 3 1 3 1
dc027483-c1c1-4449-aa5e-457dd1221803 1 1 1 1
019ca613-172c-43ab-ad67-47dd78291c5f 3 1 3 1
871a209a-7cbe-4c48-b5d9-49cd828c70f3 1 1 1 1
434f2317-9479-41c8-b406-4aeef32f73f8 1 1 1 1
d2c85483-4ffc-4af6-abca-4b92c56ff5c1 1 1 1 1
e8682657-7c58-4926-8606-4c358b7db09d 1 1 1 1
b886f443-3956-4c32-91ce-4ca998bf2b98 1 1 1 1
ece5a78f-804b-4610-89d7-4da879cb9082 1 1 1 1
af086096-3f8b-4272-9041-4f2a3d459bbb 1 1 1 1
3796f39e-e0f7-4f48-88a6-4f971c10b351 1 1 1 1
35e1419d-ac65-4305-adfd-50b4cb1ad7bf 1 1 1 1
4342a7b3-891f-46cb-9fca-5131ead4cf73 1 1 1 1
0ea6b126-864c-4647-b997-5224dfe460aa 1 1 1 1
a5da0fcc-4b07-4e82-aa52-5243dfb36777 1 1 1 1
7d5a2f59-e318-48f2-8b2c-526fd091614a 1 1 1 1
6c8803f6-b56d-4033-b24b-55a2f2317f15 1 1 1 1
1f491435-6e07-44c0-a7eb-57a8b23eac11 1 1 1 1
4a71d4b6-62ee-4bcc-aba8-5870917316bb 3 1 3 1
35ad391f-a302-4c9a-a1a2-5945fe409a62 1 1 1 1
f445be01-2386-4fc2-a3ca-5c1052e48e76 1 1 1 1
ce547656-efd9-4649-b7a6-5cfc92e7d583 1 1 1 1
67204815-5122-4935-9e39-5e2cbe1cfe47 3 1 3 1
143f9faf-85ce-4470-b76a-5f55e3fcc3a2 3 1 3 1
086fbc66-df6d-46cf-97d4-61a33573c505 3 1 3 1
58fe602f-f754-4efc-bdfa-63d7571c1c24 3 1 3 1
d8b9563c-c4ac-4280-891d-65f52f846249 3 1 3 1
a96236fc-e731-4599-9ea5-67c00bd25ec0 3 1 3 1
0f2be73d-8bb3-4461-8a5d-6a0c29f83241 3 1 3 1
aee3c9f4-c219-438d-84ee-6c5e3bf074b7 3 1 3 1
6d4ed8cd-579d-4b7c-b44a-6cff4aabec20 3 1 3 1
33f98549-2225-4557-865b-722a37134173 7 1 7 1
4f5625f4-bf82-4bc8-91c0-7407f7e2384b 1 1 1 1
9bf2c427-ff7e-4765-8bcb-7592f243f6e8 3 1 3 1
7c6af643-5ce8-4929-bd5e-7821aeaaefcb 7 1 7 1
c1b69eac-9620-40e4-a6ed-78aa8b039e21 3 1 3 1
27b711fe-0b77-4ea4-ad1a-7c239956bef4 3 1 3 1
d7d21f00-02fa-41bb-a300-7ca79e26d6ef 1 1 1 1
9fecc643-163f-4221-82f4-7db0c267b5ce 1 1 1 1
7bf2ed5c-b2c4-4c2e-9732-7e1495a9d59c 1 1 1 1
fb4d2557-6b0c-4739-994b-7e4dc0da5005 1 1 1 1
9db66331-11a5-4be7-90d3-8043c2a3b210 1 1 1 1
40752bc7-0efc-48ac-b6ad-80cb52a0aa32 1 1 1 1
2139d2ad-ba56-47d1-9273-8181e055ed1d 1 1 1 1
7903b768-d573-49c2-8007-82a466d112b2 1 1 1 1
7b838b44-9b4b-4268-b4c8-836a9022caed 1 1 1 1
eac3ac1c-3d1a-4ef2-b2e0-83d86b7f4260 1 1 1 1
1f95169b-fb08-43a1-940b-852fa4e97fe6 1 1 1 1
bcdd293d-64a9-453f-bccc-87a4b884f311 1 1 1 1
a29da87f-326c-4450-b1c6-87cb477a732f 1 1 1 1
5f32c413-efd3-460c-9fdd-88f8504230f4 1 1 1 1
bc481b9c-1ccb-4cbc-8152-89da596c93d0 1 1 1 1
12b4f2a1-131f-47d6-bf07-8b4afdbf36b3 1 1 1 1
d633c207-8ba5-414d-87b5-8ba1ffbf9482 1 1 1 1
ffc1f8d0-f9c4-452b-a827-8dfba61fe1a4 1 1 1 1
6ab429f1-8778-4c0e-b346-8e32346d4963 1 1 1 1
843ae863-48a1-4e98-8f4b-8f20790372f6 1 1 1 1
dd1308b7-9972-479c-9e65-9143e5279cc0 1 1 1 1
c76260e4-72de-4dfd-a969-921302134ae7 1 1 1 1
cf66ac74-71cc-4e2c-a1b9-9254c492bc32 1 1 1 1
9b4278bd-6c79-454d-9ba1-9342f445106b 1 1 1 1
5fdaa339-aafd-4bc4-aa78-94926adafc13 1 1 1 1
ff93ac1f-49dc-4a67-9c96-9592cce6d2b1 1 1 1 1
f9d280f0-0081-4884-896d-95ff7ec520ab 1 1 1 1
23970497-e475-48dc-9a38-96dc956f4608 1 1 1 1
436204c6-2266-4f99-9a32-97a0016ab189 1 1 1 1
58dba248-dcc0-49a4-9a14-98d2872ffc4f 1 1 1 1
3754699e-f05f-451b-bfae-9ca15ebfc377 3 1 3 1
be469616-b279-452f-8c41-9eb30b2e935a 1 1 1 1
fe624a90-9b5f-4287-8b14-9eea867892af 1 1 1 1
4cfc5a24-0305-454c-8c4f-a02e13bcb75c 1 1 1 1
e91b2c2d-a400-4945-9ce0-a1d59063c3c6 1 1 1 1
06c4205a-e342-4216-ae2e-a231b2012b08 1 1 1 1
870fa4a2-b3d5-4057-a2b1-a2caf6a31db0 1 1 1 1
f5171c6e-995d-49d8-86bd-a30878e0e05d 1 1 1 1
ba2f7f0d-24a2-4f73-a197-a57b40dc31d6 3 1 3 1
92f44aee-9667-4c65-a4e4-a78be52fd033 1 1 1 1
8a0b46a3-7336-4f9a-aa82-a90380e33572 1 1 1 1
25dcffd9-dac8-4aff-918f-a96011a03607 1 1 1 1
3d26662b-8965-4931-a80e-aa04645f9cf9 1 1 1 1
cfe810ce-610a-4131-9b65-abe4affe6d9f 1 1 1 1
1ac1972e-b7e5-49fc-88ab-ac938590f955 1 1 1 1
1b1f3866-8078-440e-aa15-ad857553ccf7 3 1 3 1
457eb971-d1c9-48ca-b947-ae7e1b114377 1 1 1 1
b5c1f1b7-ae3a-433c-b1ac-b14a2676cf28 1 1 1 1
dd7d4183-2d5b-4f4d-8bdd-b2329a58d766 1 1 1 1
d91637e6-25e8-472a-929f-b3843fc005b4 1 1 1 1
dc3eb2fb-985e-4d51-8ed6-b5b34f3cb6cd 1 1 1 1
e5609dd6-ed8e-476a-860f-b7a199930ee2 1 1 1 1
cdcac396-94f0-40af-83c2-b8e393db095c 1 1 1 1
7c2e3dfd-89db-4e32-8301-b8f382e7826c 1 1 1 1
6ab947f6-5e2a-44c1-9984-b927800d6650 1 1 1 1
33713b2b-4275-4004-82e0-baa66e63b095 1 1 1 1
60fc6a5d-81a2-483b-be4a-bb2a70f8bf1b 1 1 1 1
cb74499a-2819-4d7c-b8e3-bbba7a625f9b 1 1 1 1
8ec6afac-c0a3-4825-9978-bc3faf6225e4 1 1 1 1
13302081-de14-494e-8c18-bc6849760168 1 1 1 1
0ec4e533-8225-4fe6-a9a3-bd7a0af1d4a4 1 1 1 1
7d3e5cb5-0943-4c0f-8fc2-be2cb8f69d56 1 1 1 1
796240c6-64b1-48f6-91e5-bf584fadb20d 1 1 1 1
c911e0ef-467b-4888-9a67-bf6f81645a62 1 1 1 1
e8f6ef53-26b0-4e3d-b276-c2fda7949ffc 2 1 2 1
3fbbc5c7-8506-4fa6-8bd1-c5e3cfde5a72 3 1 3 1
0ee62dea-0281-4512-89ff-c745a207c91b 3 1 3 1
af988f8e-4fec-4c77-9d51-c869c7ce2628 3 1 3 1
6a155b5e-7e94-4a79-ac70-ca099b86981e 3 1 3 1
ef822d3d-ca91-4aba-b4cc-ccf9dd8692dd 7 1 7 1
63718da1-464b-4325-9514-cdee46cb124f 3 1 3 1
afc7ac0d-8ec3-4143-bbc1-d0ab2fd21ac5 7 1 7 1
f125c363-21a0-4bbe-a5fe-d2fc974098e1 3 1 3 1
311e3bd2-cf50-45bc-9385-d3ca59b404f0 3 1 3 1
cd3fb612-33da-40be-9367-d613f8a36ef3 3 1 3 1
b6bb40ee-1a7b-4dd9-967f-d80140fe5253 3 1 3 1
a21f9c48-0c03-41b7-a943-db14238bad8e 3 1 3 1
ebd91f48-7809-4949-b88d-de3405ffa143 3 1 3 1
11089557-0c5b-4d65-96c6-dfbd32e50ad1 3 1 3 1
cca6dba4-0483-4292-a44e-e1aa3b49f63c 3 1 3 1
d119c9ad-6066-46d6-8b96-e44bdaaa6553 3 1 3 1
ee509f88-cf3e-4cd7-acae-e68c4b924e66 3 1 3 1
7b95b3d9-69f9-462a-b610-e89e3e66c4d3 3 1 3 1
bba0194a-605b-4c97-943b-e9bf4e51fa9e 3 1 3 1
6b1ebf89-40ca-471c-a243-ea6e178aef1b 3 1 3 1
0020931c-087c-42f8-b441-ebe3d3b5f51e 3 1 3 1
f7bddb48-fa74-41e5-8913-ecba4393254b 3 1 3 1
90c39e08-4171-425a-80a1-eff5a5ba5c63 3 1 3 1
ada1f2d1-9375-427f-93a8-f333c9781199 7 1 7 1
a1896489-4925-4abc-96c4-f66ba6f171c9 3 1 3 1
4679b501-de36-4e38-859a-f72d88f96d8d 3 1 3 1
e01898ab-30b3-4d3d-9355-f8549584c9d7 3 1 3 1
fb5d3790-15c5-4433-b112-f98f20993daa 3 1 3 1
c2d8594e-599b-45d2-8876-fad32a2b1bb4 3 1 3 1
e1138b2a-b3a2-44f0-9e9b-fcd948766830 3 1 3 1
07768f40-6e46-430f-ac1a-ff6a3629729c 3 1 3 1
c83cd1ba-dc3a-44c6-b3ee-ffcd33c64428 0 1 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_SpecialOfferProduct_ProductID Aug 8 2010 5:23PM 538 538 173 0.7625 8 false 538

Detailed Statistics Density

All Density Average Length Columns
0.00338983 4 ProductID
0.001858736 8 ProductID, SpecialOfferID

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
680 0 1 0 1
707 1 5 1 1
708 0 5 0 1
709 0 4 0 1
711 1 5 1 1
712 0 4 0 1
714 1 3 1 1
715 0 4 0 1
716 0 2 0 1
718 1 1 1 1
720 1 1 1 1
722 1 2 1 1
724 2 2 1 2
725 0 3 0 1
727 2 2 1 2
729 2 2 1 2
730 0 3 0 1
732 1 1 1 1
734 1 1 1 1
736 1 2 1 1
737 0 2 0 1
738 0 3 0 1
740 1 1 1 1
742 1 1 1 1
744 1 1 1 1
746 1 1 1 1
748 1 2 1 1
750 1 1 1 1
752 1 1 1 1
754 1 2 1 1
756 1 1 1 1
758 1 1 1 1
760 1 3 1 1
761 0 3 0 1
762 0 4 0 1
763 0 3 0 1
765 1 3 1 1
766 0 2 0 1
768 1 2 1 1
770 1 3 1 1
771 0 2 0 1
773 3 3 1 3
774 0 2 0 1
776 3 3 1 3
777 0 3 0 1
779 2 2 1 2
780 0 3 0 1
781 0 2 0 1
782 0 4 0 1
784 3 3 1 3
786 2 2 1 2
788 1 2 1 1
789 0 3 0 1
790 0 2 0 1
792 1 1 1 1
793 0 2 0 1
794 0 3 0 1
796 1 1 1 1
798 2 2 1 2
800 1 1 1 1
801 0 3 0 1
803 1 1 1 1
804 0 2 0 1
806 1 3 1 1
808 1 3 1 1
809 0 2 0 1
811 1 1 1 1
813 1 1 1 1
815 1 2 1 1
817 1 1 1 1
819 1 1 1 1
821 1 1 1 1
823 1 1 1 1
825 3 3 1 3
827 1 1 1 1
829 1 1 1 1
832 2 2 2 1
835 2 3 2 1
837 1 1 1 1
839 1 1 1 1
841 1 2 1 1
843 1 2 1 1
844 0 2 0 1
846 1 1 1 1
848 1 1 1 1
849 0 3 0 1
852 2 4 2 1
854 1 3 1 1
855 0 2 0 1
856 0 3 0 1
858 1 3 1 1
859 0 3 0 1
860 0 2 0 1
862 1 4 1 1
863 0 5 0 1
864 0 4 0 1
865 0 3 0 1
867 1 4 1 1
869 1 5 1 1
870 0 4 0 1
872 1 1 1 1
874 2 2 1 2
876 4 4 1 4
877 0 4 0 1
879 1 1 1 1
881 3 3 1 3
883 1 3 1 1
884 0 4 0 1
886 2 2 1 2
888 1 1 1 1
889 0 2 0 1
891 1 1 1 1
893 3 3 1 3
895 1 1 1 1
897 1 1 1 1
899 1 2 1 1
901 1 1 1 1
903 1 1 1 1
904 0 2 0 1
906 1 1 1 1
908 1 2 1 1
909 0 2 0 1
911 1 1 1 1
913 1 1 1 1
915 1 1 1 1
917 1 2 1 1
919 1 1 1 1
921 1 1 1 1
923 1 1 1 1
925 1 2 1 1
927 1 1 1 1
929 2 2 1 2
930 0 2 0 1
932 1 1 1 1
934 1 1 1 1
936 2 2 1 2
937 0 3 0 1
939 2 2 1 2
941 2 2 1 2
943 1 1 1 1
945 2 2 1 2
947 1 1 1 1
948 0 2 0 1
950 1 1 1 1
952 2 2 1 2
953 0 2 0 1
954 0 4 0 1
956 2 2 1 2
957 0 4 0 1
959 2 2 1 2
960 0 2 0 1
961 0 3 0 1
963 2 2 1 2
964 0 2 0 1
966 3 3 1 3
968 1 1 1 1
969 0 3 0 1
970 0 2 0 1
972 1 3 1 1
974 3 3 1 3
976 1 4 1 1
978 1 2 1 1
979 0 4 0 1
981 1 2 1 1
983 1 2 1 1
985 2 2 1 2
987 2 2 1 2
988 0 2 0 1
990 1 1 1 1
993 2 1 2 1
996 2 1 2 1
998 1 3 1 1
999 0 2 0 1

Objects that depend on [SpecialOfferProduct]

Objects on which [SpecialOfferProduct] depends

SQL

Script
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[SpecialOfferProduct]( [SpecialOfferID] [int] NOT NULL, [ProductID] [int] 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 SpecialOfferProduct records.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SpecialOfferProduct', @level2type=N'COLUMN',@level2name=N'SpecialOfferID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product identification number. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SpecialOfferProduct', @level2type=N'COLUMN',@level2name=N'ProductID'
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'SpecialOfferProduct', @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'SpecialOfferProduct', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Cross-reference table mapping products to special offer discounts.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SpecialOfferProduct'

See also

List of Tables