Table: SalesOrderDetail

Properties

Property	Value
Name	SalesOrderDetail
ID	898102240
Owner	dbo
Schema	Sales
Filegroup	PRIMARY
Data Size (KB)	9864 KB
Index Size (KB)	5144 KB
Rows	121317
Unused (KB)	248 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:44 PM
Create Date	8/8/2010 5:21:52 PM

Extended Properties

Name	Value
MS_Description	Individual products associated with a specific sales order. See SalesOrderHeader.

Columns

Column ID	Column Name	Datatype
1	SalesOrderID	int
2	SalesOrderDetailID	int
3	CarrierTrackingNumber	nvarchar(25)
4	OrderQty	smallint
5	ProductID	int
6	SpecialOfferID	int
7	UnitPrice	money
8	UnitPriceDiscount	money
9	LineTotal	numeric(38,6)
10	rowguid	uniqueidentifier
11	ModifiedDate	datetime

Identity Columns

Column	Seed Value	Increment Value	Last Value	Is Not For Replication	Is Computed	Is Sparse	Is Column Set
SalesOrderDetailID	1	1	121317

Primary Key Constraints

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

Primary Key Columns

Name
SalesOrderID
SalesOrderDetailID

Foreign Keys

Name	Referenced Object	Update Action	Delete Action
FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID	Sales.SalesOrderHeader	No action	Cascade
FK_SalesOrderDetail_SpecialOfferProduct_SpecialOfferIDProductID	Sales.SpecialOfferProduct	No action	No action

Column Level Check Constraints

Name	Column ID	Column	Definition
CK_SalesOrderDetail_OrderQty	4	OrderQty	([OrderQty]>(0))
CK_SalesOrderDetail_UnitPrice	7	UnitPrice	([UnitPrice]>=(0.00))
CK_SalesOrderDetail_UnitPriceDiscount	8	UnitPriceDiscount	([UnitPriceDiscount]>=(0.00))

Table Level Check Constraints

No table constraints defined.

Default Constraints

Name	Column	Definition	Extended Property Name	Extended Property Value
DF_SalesOrderDetail_UnitPriceDiscount	UnitPriceDiscount	((0.0))	MS_Description	Default constraint value of 0.0
DF_SalesOrderDetail_rowguid	rowguid	(newid())	MS_Description	Default constraint value of NEWID()
DF_SalesOrderDetail_ModifiedDate	ModifiedDate	(getdate())	MS_Description	Default constraint value of GETDATE()

Indexes

Name	Index Type	Primary Key	Unique	Unique Constraint	Ignore Duplicate Key	Disabled
PK_SalesOrderDetail_SalesOrderID_SalesOrderDetailID	CLUSTERED
AK_SalesOrderDetail_rowguid	NONCLUSTERED
IX_SalesOrderDetail_ProductID	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_SalesOrderDetail_SalesOrderID_SalesOrderDetailID	Aug 8 2010 5:22PM	121317	121317	146	0.2689388	8			121317

Detailed Statistics Density

All Density	Average Length	Columns
3.178134E-05	4	SalesOrderID
8.242868E-06	8	SalesOrderID, SalesOrderDetailID

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
43659	0	12	0	1
43692	282	28	32	8.8125
43898	716	28	205	3.492683
44079	403	27	180	2.238889
44288	766	34	208	3.682692
44488	570	27	199	2.864322
44538	614	35	49	12.53061
44570	370	32	31	11.93548
44758	409	27	187	2.187166
44801	504	26	42	12
45047	306	26	245	1.24898
45288	647	27	240	2.695833
45344	644	22	55	11.70909
45550	509	26	205	2.482927
45779	488	14	228	2.140351
46028	716	29	248	2.887097
46049	249	35	20	12.45
46105	715	35	55	13
46333	348	36	227	1.53304
46387	634	29	53	11.96226
46614	444	60	226	1.964602
46638	437	53	23	19
46662	505	57	23	21.95652
46930	641	21	267	2.400749
46957	446	56	26	17.15385
46988	683	59	30	22.76667
47018	620	57	29	21.37931
47042	489	53	23	21.26087
47068	479	1	25	19.16
47355	421	68	286	1.472028
47395	665	66	39	17.05128
47422	478	57	26	18.38461
47447	367	56	24	15.29167
47670	731	57	222	3.292793
47716	730	55	45	16.22222
47960	547	8	243	2.251029
47988	389	51	27	14.40741
48012	466	52	23	20.26087
48043	505	46	30	16.83333
48063	345	47	19	18.15789
48295	698	56	231	3.021645
48336	558	56	40	13.95
48363	383	49	26	14.73077
48392	377	50	28	13.46429
48750	686	44	357	1.921569
48786	592	43	35	16.91429
49058	462	41	271	1.704797
49100	502	20	41	12.2439
49129	416	42	28	14.85714
49169	478	21	39	12.25641
49464	339	41	294	1.153061
49501	559	43	36	15.52778
49538	407	33	36	11.30556
49828	537	58	289	1.858132
49855	473	46	26	18.19231
49888	456	52	32	14.25
50191	493	34	302	1.63245
50226	650	55	34	19.11765
50259	459	47	32	14.34375
50289	339	53	29	11.68966
50322	601	41	32	18.78125
50661	341	31	338	1.008876
50694	687	53	32	21.46875
50722	354	43	27	13.11111
50756	474	36	33	14.36364
51081	335	51	324	1.033951
51120	834	67	38	21.94737
51148	695	44	27	25.74074
51169	427	46	20	21.35
51536	1028	2	366	2.808743
51711	735	55	174	4.224138
51721	249	72	9	27.66667
51748	459	64	26	17.65385
51783	766	43	34	22.52941
51822	513	62	38	13.5
51839	520	49	16	32.5
51864	507	21	24	21.125
53337	3598	4	1472	2.444293
53468	763	52	130	5.869231
53536	1560	61	67	23.28358
53573	754	53	36	20.94444
53613	507	50	39	13
53632	253	4	18	14.05556
55233	3870	25	1600	2.41875
55258	577	9	24	24.04167
55301	755	57	42	17.97619
55324	255	38	22	11.59091
55503	508	4	178	2.853933
56732	3071	2	1228	2.500814
57017	762	22	284	2.683099
57051	550	46	33	16.66667
57093	755	41	41	18.41463
57137	639	52	43	14.86047
57168	445	45	30	14.83333
57321	510	2	152	3.355263
58787	3587	6	1465	2.448464
58918	647	65	130	4.976923
58951	676	43	32	21.125
58972	385	50	20	19.25
59010	423	46	37	11.43243
59044	506	32	33	15.33333
59068	262	46	23	11.3913
59419	1023	2	350	2.922857
60866	3590	2	1446	2.482711
61184	958	44	317	3.022082
61222	506	20	37	13.67568
61249	492	20	26	18.92308
61428	509	4	178	2.85955
63080	4098	3	1651	2.482132
63156	510	18	75	6.8
63201	497	25	44	11.29545
63241	500	23	39	12.82051
63285	483	35	43	11.23256
63462	510	4	176	2.897727
64508	2597	4	1045	2.485168
64698	508	5	189	2.687831
65018	767	4	319	2.404389
65160	480	37	141	3.404255
65238	1098	37	77	14.25974
65280	480	32	41	11.70732
65507	766	3	226	3.38938
67083	3844	2	1575	2.440635
67263	516	29	179	2.882682
67289	603	57	25	24.12
67324	580	42	34	17.05882
67498	767	2	173	4.433526
68431	2303	3	932	2.47103
68722	764	4	290	2.634483
69343	1535	2	620	2.475806
69418	587	35	74	7.932433
69454	591	46	35	16.88571
69511	751	40	56	13.41071
69558	746	31	46	16.21739
69830	767	3	271	2.830258
71345	3841	2	1514	2.536988
71669	767	5	323	2.374613
71794	615	61	124	4.959677
71829	744	28	34	21.88235
71880	746	35	50	14.92
71938	746	42	57	13.08772
72157	765	3	218	3.509174
73061	2302	4	903	2.54928
74306	3073	3	1244	2.470257
74660	767	3	353	2.172805
75122	1077	2	461	2.336226
75123	0	3	0	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
AK_SalesOrderDetail_rowguid	Aug 8 2010 5:23PM	121317	121317	47	1	24			121317

Detailed Statistics Density

All Density	Average Length	Columns
8.242868E-06	16	rowguid
8.242868E-06	20	rowguid, SalesOrderID
8.242868E-06	24	rowguid, SalesOrderID, SalesOrderDetailID

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
27520246-6cbe-4942-ac28-0000957540c9	0	1	0	1
38e43faf-fa37-44a5-9fbb-05f1f4557470	2758	1	2758	1
755adc80-c0b7-4a06-a177-06f7c3292868	511	1	511	1
8af67b80-7741-423e-bd32-08adcca1d8fc	767	1	767	1
8656696a-66b7-433f-a7b7-0ac62fd27a2f	1023	1	1023	1
76f135c7-6f9b-4bcd-80a8-19c1b6b798fa	6911	1	6911	1
3fbb68d2-2583-45ba-8700-1e7ffd9ac6a5	2303	1	2303	1
07adde79-fa0f-49e3-a324-23bac6105e42	2559	1	2559	1
e94a93dd-1b31-4f66-88ab-2cc3d1fa360e	4351	1	4351	1
a60c426e-a160-422e-a999-434f5060d069	10751	1	10751	1
0c1c87ab-db83-47f7-ac08-48e11e6491e9	2559	1	2559	1
a70ec137-3714-4358-8ca2-49e1903f10a8	511	1	511	1
667ba6a1-78d5-4f5d-a08c-58f837228421	6911	1	6911	1
897f044c-59e1-4f6d-92d5-5dd31c0f7b0b	2303	1	2303	1
ec07c5f2-c6ad-494c-8c6a-60ef16cca242	1535	1	1535	1
5d267738-52bc-4254-be97-63419abd14ca	1023	1	1023	1
97057efe-8e51-453e-8df9-68a0399674fd	2559	1	2559	1
57fb4917-fc29-44ca-b752-6d1b42048242	2047	1	2047	1
1f20fa35-2b71-4a80-8799-6e167f45db37	511	1	511	1
81e0f4aa-4d3a-4b87-ad5d-74615585be33	3071	1	3071	1
90b4df17-54b0-45a9-a9d0-758bcab33c4e	511	1	511	1
d442ca16-5ad9-47ae-bc8e-78b8070ae15c	1535	1	1535	1
6298fafe-7ec4-4914-9ead-7d1b30406678	2047	1	2047	1
71c68580-8e12-4ed3-b923-7e18229d18d9	511	1	511	1
f52146b2-82af-4923-b122-82838404d3ff	2047	1	2047	1
5a6b59d3-f2ca-4693-b533-8489fc5d1ef5	1023	1	1023	1
dd488881-5147-4579-a13c-8b1650519fd0	3071	1	3071	1
3b731a85-543a-40e6-9de0-9d0057bd2eef	8703	1	8703	1
f47735e8-db2a-42de-97c8-a037ee430203	1535	1	1535	1
8d8b45b8-7560-4b33-aab3-a8e66b435e2b	4095	1	4095	1
e699fa06-32b5-4f62-80c0-aafaf1a72cc8	1023	1	1023	1
38ec0921-0331-4992-8e29-ae74fbffd42e	1535	1	1535	1
4d81419e-f6b1-4358-b754-af88a9e8c2ce	511	1	511	1
85aa2ec9-9906-46ca-8495-b06791b447e0	511	1	511	1
768957f1-6997-4904-80e1-b5cb74a016a2	2559	1	2559	1
b6c1369b-590d-464a-9294-b6f2a131f7c5	511	1	511	1
9f83c1a8-cc3e-4b8e-9471-c40abd6a4633	6143	1	6143	1
963ba77b-128f-44f1-b6c9-c50ed1ad110b	511	1	511	1
b3455ce4-6438-497d-a82a-ceb9b2c47618	4607	1	4607	1
c3df2252-abd3-4683-b4cd-d5b10e3a25df	3071	1	3071	1
08d2024d-bf58-46fe-a361-d73394a8602b	767	1	767	1
721d5c56-a377-41f2-a5c6-df1bcfa0b192	3839	1	3839	1
02d0daf3-8c52-4e4f-aaa4-ea8347cf7883	5375	1	5375	1
7d738f6b-9825-4fd3-9d21-f703cbced4f4	5887	1	5887	1
ced9e87b-56c3-4db9-9b69-ff5caeec47b6	4095	1	4095	1
29d31ab6-00d5-4fda-8161-ffff0e02ae6e	283	1	283	1
7762b051-2a02-4488-a42d-ffff46488486	0	1	0	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
IX_SalesOrderDetail_ProductID	Aug 8 2010 5:23PM	121317	121317	200	0.007575758	12			121317

Detailed Statistics Density

All Density	Average Length	Columns
0.003759399	4	ProductID
8.242868E-06	8	ProductID, SalesOrderID
8.242868E-06	12	ProductID, SalesOrderID, SalesOrderDetailID

Detailed Statistics Histogram

Range High Key	Range Rows	Estimated Rows	Distinct Range Rows	Avg Range Rows
707	0	3083	0	1
708	0	3007	0	1
709	0	188	0	1
710	0	44	0	1
711	0	3090	0	1
712	0	3382	0	1
713	0	429	0	1
714	0	1218	0	1
715	0	1635	0	1
716	0	1076	0	1
718	218	219	1	218
719	0	44	0	1
722	0	392	0	1
723	0	52	0	1
725	0	374	0	1
726	0	288	0	1
727	0	48	0	1
729	0	375	0	1
730	0	288	0	1
732	0	130	0	1
738	154	600	2	77
741	167	94	1	167
742	0	288	0	1
743	0	481	0	1
747	89	289	2	44.5
748	0	491	0	1
749	0	470	0	1
750	0	358	0	1
751	0	409	0	1
752	0	378	0	1
753	0	475	0	1
754	0	226	0	1
756	164	171	1	164
757	0	77	0	1
758	0	267	0	1
759	0	282	0	1
760	0	680	0	1
761	0	638	0	1
762	0	689	0	1
763	0	649	0	1
764	0	440	0	1
765	0	642	0	1
766	0	460	0	1
767	0	293	0	1
768	0	441	0	1
769	0	293	0	1
770	0	703	0	1
771	0	241	0	1
773	221	233	1	221
774	0	204	0	1
776	234	228	1	234
778	242	243	1	242
779	0	1094	0	1
780	0	1040	0	1
781	0	1054	0	1
782	0	1252	0	1
783	0	1177	0	1
784	0	1059	0	1
786	220	223	1	220
788	228	223	1	228
789	0	364	0	1
790	0	377	0	1
791	0	314	0	1
792	0	526	0	1
793	0	705	0	1
794	0	712	0	1
795	0	667	0	1
796	0	486	0	1
797	0	725	0	1
798	0	687	0	1
799	0	648	0	1
800	0	495	0	1
801	0	723	0	1
805	200	46	2	100
808	220	301	2	110
809	0	507	0	1
811	216	98	1	216
813	0	270	0	1
815	226	232	1	226
819	218	195	2	109
820	0	206	0	1
822	0	356	0	1
824	148	265	1	148
825	0	258	0	1
826	0	305	0	1
831	110	198	3	36.66667
832	0	256	0	1
833	0	88	0	1
835	0	489	0	1
836	0	350	0	1
838	0	201	0	1
843	207	260	2	103.5
844	0	267	0	1
849	0	283	0	1
850	0	131	0	1
852	0	422	0	1
853	0	114	0	1
854	0	441	0	1
856	231	353	1	231
857	0	178	0	1
858	0	883	0	1
859	0	1086	0	1
860	0	673	0	1
862	240	359	1	240
863	0	364	0	1
864	0	682	0	1
865	0	555	0	1
866	0	201	0	1
867	0	648	0	1
868	0	681	0	1
869	0	707	0	1
870	0	4688	0	1
871	0	2025	0	1
872	0	1712	0	1
873	0	3354	0	1
874	0	593	0	1
875	0	604	0	1
876	0	796	0	1
877	0	1327	0	1
878	0	2121	0	1
879	0	249	0	1
880	0	1074	0	1
881	0	717	0	1
882	0	407	0	1
883	0	805	0	1
884	0	904	0	1
886	135	130	1	135
889	80	161	2	40
892	116	169	2	58
894	140	145	1	140
898	227	9	3	75.66666
900	117	110	1	117
904	34	253	2	17
905	0	230	0	1
907	87	113	1	87
909	153	138	1	153
910	0	222	0	1
916	150	177	4	37.5
918	224	159	1	224
919	0	16	0	1
920	0	159	0	1
921	0	3095	0	1
922	0	2376	0	1
923	0	1488	0	1
924	0	162	0	1
926	227	164	1	227
927	0	9	0	1
928	0	862	0	1
929	0	1161	0	1
930	0	1396	0	1
931	0	1044	0	1
932	0	926	0	1
933	0	858	0	1
934	0	935	0	1
936	195	158	1	195
938	255	309	1	255
939	0	265	0	1
940	0	264	0	1
944	82	164	3	27.33333
945	0	257	0	1
948	139	266	2	69.5
949	0	176	0	1
950	0	28	0	1
952	219	250	1	219
953	0	346	0	1
954	0	440	0	1
955	0	342	0	1
956	0	271	0	1
957	0	433	0	1
958	0	281	0	1
960	239	157	1	239
961	0	318	0	1
962	0	280	0	1
964	227	159	1	227
965	0	319	0	1
966	0	442	0	1
967	0	336	0	1
968	0	277	0	1
969	0	439	0	1
970	0	283	0	1
971	0	198	0	1
972	0	380	0	1
973	0	573	0	1
974	0	455	0	1
975	0	332	0	1
976	0	566	0	1
977	0	537	0	1
978	0	157	0	1
979	0	306	0	1
981	253	301	1	253
983	231	239	1	231
985	221	221	1	221
987	195	228	1	195
989	236	150	1	236
991	195	193	1	195
993	232	146	1	232
996	150	218	1	150
997	0	466	0	1
998	0	685	0	1
999	0	696	0	1

Detailed Statistics General

Name	Updated	Rows	Rows Sampled	Steps	Density	Average Key Length	String Index	Filter Expression	Unfiltered Rows
_WA_Sys_00000006_3587F3E0	Aug 8 2010 5:23PM	121317	110986	12	0	4			121317

Detailed Statistics Density

All Density	Average Length	Columns
0.08333334	4	SpecialOfferID

Detailed Statistics Histogram

Range High Key	Estimated Rows	Avg Range Rows
1	115882.2	1
2	3465.076	1
3	595.7307	1
4	79.79512	1
5	2.186168	1
7	144.2871	1
8	100.5637	1
9	56.84036	1
11	84.16745	1
13	506.0978	1
14	230.6407	1
16	169.428	1

Objects that depend on [SalesOrderDetail]

Sales.SalesOrderDetail
- Sales.iduSalesOrderDetail
- Sales.ufn_SalesByStore

Objects on which [SalesOrderDetail] depends

Sales.SalesOrderDetail

SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Sales].[SalesOrderDetail]( [SalesOrderID] [int] NOT NULL, [SalesOrderDetailID] [int] IDENTITY(1,1) NOT NULL, [CarrierTrackingNumber] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OrderQty] [smallint] NOT NULL, [ProductID] [int] NOT NULL, [SpecialOfferID] [int] NOT NULL, [UnitPrice] [money] NOT NULL, [UnitPriceDiscount] [money] NOT NULL, [LineTotal] AS (isnull(([UnitPrice]((1.0)-[UnitPriceDiscount]))[OrderQty],(0.0))), [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to SalesOrderHeader.SalesOrderID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'SalesOrderID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. One incremental unique number per product sold.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'SalesOrderDetailID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipment tracking number supplied by the shipper.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'CarrierTrackingNumber' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Quantity ordered per product.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'OrderQty' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product sold to customer. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'ProductID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Promotional code. Foreign key to SpecialOffer.SpecialOfferID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'SpecialOfferID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Selling price of a single product.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'UnitPrice' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Discount amount.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'UnitPriceDiscount' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'LineTotal' 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'SalesOrderDetail', @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'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Individual products associated with a specific sales order. See SalesOrderHeader.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail'

Script

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Sales].[SalesOrderDetail]( [SalesOrderID] [int] NOT NULL, [SalesOrderDetailID] [int] IDENTITY(1,1) NOT NULL, [CarrierTrackingNumber] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [OrderQty] [smallint] NOT NULL, [ProductID] [int] NOT NULL, [SpecialOfferID] [int] NOT NULL, [UnitPrice] [money] NOT NULL, [UnitPriceDiscount] [money] NOT NULL, [LineTotal] AS (isnull(([UnitPrice]*((1.0)-[UnitPriceDiscount]))*[OrderQty],(0.0))), [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. Foreign key to SalesOrderHeader.SalesOrderID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'SalesOrderID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key. One incremental unique number per product sold.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'SalesOrderDetailID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipment tracking number supplied by the shipper.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'CarrierTrackingNumber'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Quantity ordered per product.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'OrderQty'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product sold to customer. Foreign key to Product.ProductID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'ProductID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Promotional code. Foreign key to SpecialOffer.SpecialOfferID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'SpecialOfferID'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Selling price of a single product.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'UnitPrice'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Discount amount.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'UnitPriceDiscount'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Per product subtotal. Computed as UnitPrice * (1 - UnitPriceDiscount) * OrderQty.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'LineTotal'
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'SalesOrderDetail', @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'SalesOrderDetail', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Individual products associated with a specific sales order. See SalesOrderHeader.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderDetail'

Table: SalesOrderDetail

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

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Detailed Statistics General

Detailed Statistics Density

Detailed Statistics Histogram

Objects that depend on [SalesOrderDetail]

Objects on which [SalesOrderDetail] depends

SQL

See also