# Table: ProductListPriceHistory

## Properties

Property | Value
--- | ---
Name | ProductListPriceHistory
ID | 98099390
Owner | dbo
Schema | Production
Filegroup | PRIMARY
Data Size (KB) | 24 KB
Index Size (KB) | 16 KB
Rows | 395
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:40 PM
Create Date | 8/8/2010 5:21:51 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Changes in the list price of a product over time.

## Columns

Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set
--- | --- | --- | --- | --- | ---
1 | ProductID | int |  |  |
2 | StartDate | datetime |  |  |
3 | EndDate | datetime |  |  |
4 | ListPrice | money |  |  |
5 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

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

## Primary Key Columns

Name
ProductID
StartDate

## Foreign Keys

Name | Referenced Object | Update Action | Delete Action
--- | --- | --- | ---
FK_ProductListPriceHistory_Product_ProductID | Production.Product | 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_ProductListPriceHistory_ListPrice | 4 | ListPrice | ([ListPrice]>(0.00)) |  |  |  |  |

## Table Level Check Constraints

Name | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named
--- | --- | --- | --- | --- | --- | ---
CK_ProductListPriceHistory_EndDate | ([EndDate]>=[StartDate] OR [EndDate] IS NULL) |  |  |  |  |

## Default Constraints

Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | --- | --- | ---
DF_ProductListPriceHistory_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled
--- | --- | --- | --- | --- | --- | ---
PK_ProductListPriceHistory_ProductID_StartDate | CLUSTERED |  |  |  |  |

## 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_ProductListPriceHistory_ProductID_StartDate | Aug 8 2010 5:22PM | 395 | 395 | 152 | 0.75 | 12 |  |  | 395

### Detailed Statistics Density

All Density | Average Length | Columns
--- | --- | ---
0.003412969 | 4 | ProductID
0.002531646 | 12 | ProductID, StartDate

### Detailed Statistics Histogram

Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows
--- | --- | --- | --- | ---
707 | 0 | 3 | 0 | 1
708 | 0 | 3 | 0 | 1
710 | 1 | 1 | 1 | 1
712 | 3 | 3 | 1 | 3
714 | 3 | 3 | 1 | 3
716 | 3 | 3 | 1 | 3
718 | 3 | 3 | 1 | 3
720 | 3 | 3 | 1 | 3
722 | 3 | 3 | 1 | 3
724 | 3 | 3 | 1 | 3
726 | 2 | 2 | 1 | 2
728 | 2 | 2 | 1 | 2
730 | 2 | 2 | 1 | 2
732 | 1 | 1 | 1 | 1
734 | 1 | 1 | 1 | 1
735 | 0 | 1 | 0 | 1
737 | 3 | 3 | 1 | 3
739 | 3 | 3 | 1 | 3
741 | 1 | 1 | 1 | 1
743 | 3 | 3 | 1 | 3
745 | 1 | 1 | 1 | 1
747 | 3 | 3 | 1 | 3
748 | 0 | 3 | 0 | 1
750 | 1 | 1 | 1 | 1
752 | 1 | 1 | 1 | 1
754 | 1 | 1 | 1 | 1
756 | 1 | 1 | 1 | 1
758 | 1 | 1 | 1 | 1
760 | 2 | 2 | 1 | 2
762 | 2 | 2 | 1 | 2
764 | 2 | 2 | 1 | 2
766 | 2 | 2 | 1 | 2
768 | 2 | 2 | 1 | 2
770 | 2 | 2 | 1 | 2
772 | 1 | 1 | 1 | 1
774 | 1 | 1 | 1 | 1
776 | 1 | 1 | 1 | 1
778 | 1 | 1 | 1 | 1
780 | 2 | 2 | 1 | 2
782 | 2 | 2 | 1 | 2
784 | 2 | 2 | 1 | 2
786 | 1 | 1 | 1 | 1
788 | 1 | 1 | 1 | 1
790 | 1 | 1 | 1 | 1
791 | 0 | 1 | 0 | 1
793 | 2 | 2 | 1 | 2
795 | 2 | 2 | 1 | 2
797 | 2 | 2 | 1 | 2
799 | 2 | 2 | 1 | 2
801 | 2 | 2 | 1 | 2
803 | 1 | 1 | 1 | 1
805 | 1 | 1 | 1 | 1
807 | 1 | 1 | 1 | 1
809 | 2 | 2 | 1 | 2
811 | 2 | 2 | 1 | 2
813 | 2 | 2 | 1 | 2
815 | 1 | 1 | 1 | 1
817 | 1 | 1 | 1 | 1
819 | 1 | 1 | 1 | 1
821 | 1 | 1 | 1 | 1
822 | 0 | 2 | 0 | 1
824 | 1 | 1 | 1 | 1
826 | 1 | 1 | 1 | 1
828 | 1 | 1 | 1 | 1
830 | 1 | 1 | 1 | 1
832 | 1 | 1 | 1 | 1
834 | 2 | 2 | 1 | 2
836 | 2 | 2 | 1 | 2
838 | 2 | 2 | 1 | 2
840 | 2 | 2 | 1 | 2
842 | 1 | 1 | 1 | 1
844 | 1 | 1 | 1 | 1
846 | 1 | 1 | 1 | 1
848 | 1 | 1 | 1 | 1
850 | 1 | 1 | 1 | 1
852 | 1 | 1 | 1 | 1
854 | 1 | 1 | 1 | 1
856 | 1 | 1 | 1 | 1
857 | 0 | 1 | 0 | 1
859 | 2 | 2 | 1 | 2
860 | 0 | 2 | 0 | 1
862 | 1 | 1 | 1 | 1
864 | 1 | 1 | 1 | 1
866 | 1 | 1 | 1 | 1
868 | 1 | 1 | 1 | 1
870 | 1 | 1 | 1 | 1
872 | 1 | 1 | 1 | 1
874 | 1 | 1 | 1 | 1
876 | 1 | 1 | 1 | 1
878 | 1 | 1 | 1 | 1
880 | 1 | 1 | 1 | 1
882 | 1 | 1 | 1 | 1
884 | 1 | 1 | 1 | 1
886 | 1 | 1 | 1 | 1
888 | 1 | 1 | 1 | 1
890 | 1 | 1 | 1 | 1
892 | 1 | 1 | 1 | 1
894 | 1 | 1 | 1 | 1
896 | 1 | 1 | 1 | 1
898 | 1 | 1 | 1 | 1
900 | 1 | 1 | 1 | 1
902 | 1 | 1 | 1 | 1
903 | 0 | 1 | 0 | 1
905 | 1 | 1 | 1 | 1
906 | 0 | 1 | 0 | 1
908 | 1 | 1 | 1 | 1
910 | 1 | 1 | 1 | 1
912 | 1 | 1 | 1 | 1
914 | 1 | 1 | 1 | 1
916 | 1 | 1 | 1 | 1
918 | 1 | 1 | 1 | 1
920 | 1 | 1 | 1 | 1
922 | 1 | 1 | 1 | 1
924 | 1 | 1 | 1 | 1
926 | 1 | 1 | 1 | 1
928 | 1 | 1 | 1 | 1
930 | 1 | 1 | 1 | 1
932 | 1 | 1 | 1 | 1
934 | 1 | 1 | 1 | 1
936 | 1 | 1 | 1 | 1
938 | 1 | 1 | 1 | 1
940 | 1 | 1 | 1 | 1
942 | 1 | 1 | 1 | 1
944 | 1 | 1 | 1 | 1
946 | 1 | 1 | 1 | 1
948 | 1 | 1 | 1 | 1
950 | 1 | 1 | 1 | 1
952 | 1 | 1 | 1 | 1
954 | 1 | 1 | 1 | 1
956 | 1 | 1 | 1 | 1
958 | 1 | 1 | 1 | 1
960 | 1 | 1 | 1 | 1
962 | 1 | 1 | 1 | 1
964 | 1 | 1 | 1 | 1
966 | 1 | 1 | 1 | 1
968 | 1 | 1 | 1 | 1
970 | 1 | 1 | 1 | 1
972 | 1 | 1 | 1 | 1
974 | 1 | 1 | 1 | 1
976 | 1 | 1 | 1 | 1
978 | 1 | 1 | 1 | 1
980 | 1 | 1 | 1 | 1
982 | 1 | 1 | 1 | 1
984 | 1 | 1 | 1 | 1
986 | 1 | 1 | 1 | 1
988 | 1 | 1 | 1 | 1
990 | 1 | 1 | 1 | 1
992 | 1 | 1 | 1 | 1
994 | 1 | 1 | 1 | 1
996 | 1 | 1 | 1 | 1
998 | 1 | 1 | 1 | 1
999 | 0 | 1 | 0 | 1

## Objects that depend on [ProductListPriceHistory]

- Production.ProductListPriceHistory
  - dbo.ufnGetProductDealerPrice
    - Person.functionSynonym
  - dbo.ufnGetProductListPrice

## Objects on which [ProductListPriceHistory] depends

- Production.ProductListPriceHistory
  - Production.Product
    - Production.ProductSubcategory
      - Production.ProductCategory
        - dbo.Name
    - Production.UnitMeasure
    - Production.ProductModel
      - Production.ProductDescriptionSchemaCollection
      - Production.ManuInstructionsSchemaCollection
    - dbo.Flag

## SQL

Script
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [Production].[ProductListPriceHistory]( [ProductID] [int] NOT NULL, [StartDate] [datetime] NOT NULL, [EndDate] [datetime] NULL, [ListPrice] [money] NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product identification number. Foreign key to Product.ProductID' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductListPriceHistory', @level2type=N'COLUMN',@level2name=N'ProductID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'List price start date.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductListPriceHistory', @level2type=N'COLUMN',@level2name=N'StartDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'List price end date' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductListPriceHistory', @level2type=N'COLUMN',@level2name=N'EndDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product list price.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductListPriceHistory', @level2type=N'COLUMN',@level2name=N'ListPrice' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductListPriceHistory', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Changes in the list price of a product over time.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'ProductListPriceHistory'

#### See also

List of Tables