Table: [AdventureWorks2016CTP3].[Production].[Product]

CollapseAll image

Collapse image Table properties


Name  Value 
 Schema  [Production]
 Owner  [dbo]
 Table is replicated   
 Creation date  23.10.2015
 ID  146099561
 Located on  PRIMARY
 Data size KB  104 KB
 Index size KB  128 KB
 Rows  504
 ChangeTrackingEnabled   
 FileStreamFileGroup   
 FileStreamPartitionScheme   
 LockEscalation  TABLE
 TrackColumnsUpdatedEnabled   
 Table is filetable   
 Filetable directory   
 Filetable collate   
 Filetable primary key  [PK_Product_ProductID]
 Filetable streamid unique   
 Filetable fullpath unique   
 Filetable is enabled   
 Is memory optimized   
 Durability  SCHEMA_AND_DATA

Collapse image Creation options


Name  Value 
QUOTED_IDENTIFIER ON
ANSI_NULLS ON
ANSI_PADDING ON

Collapse image Columns


      Name  Description  Data type  Max length  Nullable  Default IsGUID  SPARSE Computed value
Primary key Identity   ProductID     int 4        
      Name     [dbo].[Name] 50        
      ProductNumber     nvarchar 25        
      MakeFlag     [dbo].[Flag] 1   ((1))    
      FinishedGoodsFlag     [dbo].[Flag] 1   ((1))    
      Color     nvarchar 15      
      SafetyStockLevel     smallint 2        
      ReorderPoint     smallint 2        
      StandardCost     money 8        
      ListPrice     money 8        
      Size     nvarchar 5      
    Foreign key SizeUnitMeasureCode     nchar 3      
    Foreign key WeightUnitMeasureCode     nchar 3      
      Weight     decimal 5      
      DaysToManufacture     int 4        
      ProductLine     nchar 2      
      Class     nchar 2      
      Style     nchar 2      
    Foreign key ProductSubcategoryID     int 4      
    Foreign key ProductModelID     int 4      
      SellStartDate     datetime 8        
      SellEndDate     datetime 8      
      DiscontinuedDate     datetime 8      
      rowguid     uniqueidentifier 16   (newid())  
      ModifiedDate     datetime 8   (getdate())    
Total: 25 column(s)

Collapse image Indexes


Index  Description  Primary  Unique  Size KB 
[PK_Product_ProductID] ProductID   232 0
[AK_Product_Name] Name     48 0
[AK_Product_ProductNumber] ProductNumber     32 0
[AK_Product_rowguid] rowguid     32 0
Total: 4 Index/indexes

Collapse image Columnstore indexes


No columnstore indexes exist

Collapse image Check constraints


Name  Expression 
CK_Product_Class (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL)
CK_Product_DaysToManufacture ([DaysToManufacture]>=(0))
CK_Product_ListPrice ([ListPrice]>=(0.00))
CK_Product_ProductLine (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL)
CK_Product_ReorderPoint ([ReorderPoint]>(0))
CK_Product_SafetyStockLevel ([SafetyStockLevel]>(0))
CK_Product_SellEndDate ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL)
CK_Product_StandardCost ([StandardCost]>=(0.00))
CK_Product_Style (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL)
CK_Product_Weight ([Weight]>(0.00))

Collapse image Identity column


  Name  Seed  Increment  Not for replication 
 ProductID   1   1   

Collapse image Referencing tables


Table  Foreign key  Primary key or unique constraint 
[Production].[BillOfMaterials] FK_BillOfMaterials_Product_ComponentID PK_Product_ProductID
[Production].[BillOfMaterials] FK_BillOfMaterials_Product_ProductAssemblyID PK_Product_ProductID
[Production].[ProductCostHistory] FK_ProductCostHistory_Product_ProductID PK_Product_ProductID
[Production].[ProductDocument] FK_ProductDocument_Product_ProductID PK_Product_ProductID
[Production].[ProductInventory] FK_ProductInventory_Product_ProductID PK_Product_ProductID
[Production].[ProductListPriceHistory] FK_ProductListPriceHistory_Product_ProductID PK_Product_ProductID
[Production].[ProductProductPhoto] FK_ProductProductPhoto_Product_ProductID PK_Product_ProductID
[Production].[ProductReview] FK_ProductReview_Product_ProductID PK_Product_ProductID
[Production].[TransactionHistory] FK_TransactionHistory_Product_ProductID PK_Product_ProductID
[Production].[WorkOrder] FK_WorkOrder_Product_ProductID PK_Product_ProductID
[Purchasing].[ProductVendor] FK_ProductVendor_Product_ProductID PK_Product_ProductID
[Purchasing].[PurchaseOrderDetail] FK_PurchaseOrderDetail_Product_ProductID PK_Product_ProductID
[Sales].[ShoppingCartItem] FK_ShoppingCartItem_Product_ProductID PK_Product_ProductID
[Sales].[SpecialOfferProduct] FK_SpecialOfferProduct_Product_ProductID PK_Product_ProductID
Total: 14 table(s)

Collapse image Referenced tables


Table  Primary key or unique constraint  Foreign key 
[Production].[ProductModel] PK_ProductModel_ProductModelID FK_Product_ProductModel_ProductModelID
[Production].[ProductSubcategory] PK_ProductSubcategory_ProductSubcategoryID FK_Product_ProductSubcategory_ProductSubcategoryID
[Production].[UnitMeasure] PK_UnitMeasure_UnitMeasureCode FK_Product_UnitMeasure_SizeUnitMeasureCode
[Production].[UnitMeasure] PK_UnitMeasure_UnitMeasureCode FK_Product_UnitMeasure_WeightUnitMeasureCode
Total: 4 table(s)

Collapse image Objects that depend on [Production].[Product]


Object name Object type Dep level
[dbo].[uspGetBillOfMaterials] Procedure 1
[dbo].[uspGetWhereUsedProductID] Procedure 1
[Production].[BillOfMaterials] Table 1
[Production].[ProductCostHistory] Table 1
[Production].[ProductDocument] Table 1
[Production].[ProductInventory] Table 1
[Production].[ProductListPriceHistory] Table 1
[Production].[ProductProductPhoto] Table 1
[Production].[ProductReview] Table 1
[Purchasing].[ProductVendor] Table 1
[Purchasing].[PurchaseOrderDetail] Table 1
[Sales].[ShoppingCartItem] Table 1
[Sales].[SpecialOfferProduct] Table 1
[Production].[TransactionHistory] Table 1
[Production].[WorkOrder] Table 1
[dbo].[ufnGetProductDealerPrice] Function 1
[dbo].[ufnGetProductListPrice] Function 1
[dbo].[ufnGetProductStandardCost] Function 1
[Production].[vProductAndDescription] View 1
Total 19 object(s)

Collapse image Objects that [Production].[Product] depends on


Object name Object type Dep level
[Production] Schema 1
[Production].[ProductModel] Table 1
[Production].[ProductSubcategory] Table 1
[Production].[UnitMeasure] Table 1
[dbo].[Flag] Datatype 1
[dbo].[Name] Datatype 1
Total 6 object(s)

Collapse image Extended properties


Name  Value 
MS_Description Products sold or used in the manfacturing of sold products.

Collapse image Table options


Name  Value 
Pintable OFF
Table lock on bulk load OFF
Insert row lock OFF
Text in row 0
Large value types out of row OFF

Collapse image SQL


SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [Production].[Product] (
        [ProductID]                 [int] IDENTITY(1, 1) NOT NULL,
        [Name]                      [dbo].[Name] NOT NULL,
        [ProductNumber]             [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [MakeFlag]                  [dbo].[Flag] NOT NULL,
        [FinishedGoodsFlag]         [dbo].[Flag] NOT NULL,
        [Color]                     [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [SafetyStockLevel]          [smallint] NOT NULL,
        [ReorderPoint]              [smallint] NOT NULL,
        [StandardCost]              [money] NOT NULL,
        [ListPrice]                 [money] NOT NULL,
        [Size]                      [nvarchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [SizeUnitMeasureCode]       [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [WeightUnitMeasureCode]     [nchar](3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Weight]                    [decimal](8, 2) NULL,
        [DaysToManufacture]         [int] NOT NULL,
        [ProductLine]               [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Class]                     [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Style]                     [nchar](2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [ProductSubcategoryID]      [int] NULL,
        [ProductModelID]            [int] NULL,
        [SellStartDate]             [datetime] NOT NULL,
        [SellEndDate]               [datetime] NULL,
        [DiscontinuedDate]          [datetime] NULL,
        [rowguid]                   [uniqueidentifier] NOT NULL ROWGUIDCOL,
        [ModifiedDate]              [datetime] NOT NULL,
        CONSTRAINT [PK_Product_ProductID]
        PRIMARY KEY
        CLUSTERED
        ([ProductID])
    ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key (clustered) constraint', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'PK_Product_ProductID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Clustered index created by a primary key constraint.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'INDEX', N'PK_Product_ProductID'
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_Class]
    CHECK
    (upper([Class])='H' OR upper([Class])='M' OR upper([Class])='L' OR [Class] IS NULL)
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [Class]=''h'' OR [Class]=''m'' OR [Class]=''l'' OR [Class]=''H'' OR [Class]=''M'' OR [Class]=''L'' OR [Class] IS NULL', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_Class'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_Class]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_DaysToManufacture]
    CHECK
    ([DaysToManufacture]>=(0))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [DaysToManufacture] >= (0)', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_DaysToManufacture'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_DaysToManufacture]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_ListPrice]
    CHECK
    ([ListPrice]>=(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [ListPrice] >= (0.00)', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_ListPrice'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_ListPrice]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_ProductLine]
    CHECK
    (upper([ProductLine])='R' OR upper([ProductLine])='M' OR upper([ProductLine])='T' OR upper([ProductLine])='S' OR [ProductLine] IS NULL)
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [ProductLine]=''r'' OR [ProductLine]=''m'' OR [ProductLine]=''t'' OR [ProductLine]=''s'' OR [ProductLine]=''R'' OR [ProductLine]=''M'' OR [ProductLine]=''T'' OR [ProductLine]=''S'' OR [ProductLine] IS NULL', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_ProductLine'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_ProductLine]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_ReorderPoint]
    CHECK
    ([ReorderPoint]>(0))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [ReorderPoint] > (0)', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_ReorderPoint'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_ReorderPoint]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_SafetyStockLevel]
    CHECK
    ([SafetyStockLevel]>(0))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [SafetyStockLevel] > (0)', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_SafetyStockLevel'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_SafetyStockLevel]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_SellEndDate]
    CHECK
    ([SellEndDate]>=[SellStartDate] OR [SellEndDate] IS NULL)
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [SellEndDate] >= [SellStartDate] OR [SellEndDate] IS NULL', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_SellEndDate'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_SellEndDate]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_StandardCost]
    CHECK
    ([StandardCost]>=(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [SafetyStockLevel] > (0)', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_StandardCost'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_StandardCost]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_Style]
    CHECK
    (upper([Style])='U' OR upper([Style])='M' OR upper([Style])='W' OR [Style] IS NULL)
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [Style]=''u'' OR [Style]=''m'' OR [Style]=''w'' OR [Style]=''U'' OR [Style]=''M'' OR [Style]=''W'' OR [Style] IS NULL', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_Style'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_Style]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [CK_Product_Weight]
    CHECK
    ([Weight]>(0.00))
GO
EXEC sp_addextendedproperty N'MS_Description', N'Check constraint [Weight] > (0.00)', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'CK_Product_Weight'
GO
ALTER TABLE [Production].[Product]
CHECK CONSTRAINT [CK_Product_Weight]
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [DF_Product_FinishedGoodsFlag]
    DEFAULT ((1)) FOR [FinishedGoodsFlag]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of  1', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'DF_Product_FinishedGoodsFlag'
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [DF_Product_MakeFlag]
    DEFAULT ((1)) FOR [MakeFlag]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of  1', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'DF_Product_MakeFlag'
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [DF_Product_ModifiedDate]
    DEFAULT (getdate()) FOR [ModifiedDate]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of GETDATE()', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'DF_Product_ModifiedDate'
GO
ALTER TABLE [Production].[Product]
    ADD
    CONSTRAINT [DF_Product_rowguid]
    DEFAULT (newid()) FOR [rowguid]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Default constraint value of NEWID()', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'DF_Product_rowguid'
GO
ALTER TABLE [Production].[Product]
    WITH CHECK
    ADD CONSTRAINT [FK_Product_ProductModel_ProductModelID]
    FOREIGN KEY ([ProductModelID]) REFERENCES [Production].[ProductModel] ([ProductModelID])
ALTER TABLE [Production].[Product]
    CHECK CONSTRAINT [FK_Product_ProductModel_ProductModelID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing ProductModel.ProductModelID.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'FK_Product_ProductModel_ProductModelID'
GO
ALTER TABLE [Production].[Product]
    WITH CHECK
    ADD CONSTRAINT [FK_Product_ProductSubcategory_ProductSubcategoryID]
    FOREIGN KEY ([ProductSubcategoryID]) REFERENCES [Production].[ProductSubcategory] ([ProductSubcategoryID])
ALTER TABLE [Production].[Product]
    CHECK CONSTRAINT [FK_Product_ProductSubcategory_ProductSubcategoryID]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing ProductSubcategory.ProductSubcategoryID.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'FK_Product_ProductSubcategory_ProductSubcategoryID'
GO
ALTER TABLE [Production].[Product]
    WITH CHECK
    ADD CONSTRAINT [FK_Product_UnitMeasure_SizeUnitMeasureCode]
    FOREIGN KEY ([SizeUnitMeasureCode]) REFERENCES [Production].[UnitMeasure] ([UnitMeasureCode])
ALTER TABLE [Production].[Product]
    CHECK CONSTRAINT [FK_Product_UnitMeasure_SizeUnitMeasureCode]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing UnitMeasure.UnitMeasureCode.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'FK_Product_UnitMeasure_SizeUnitMeasureCode'
GO
ALTER TABLE [Production].[Product]
    WITH CHECK
    ADD CONSTRAINT [FK_Product_UnitMeasure_WeightUnitMeasureCode]
    FOREIGN KEY ([WeightUnitMeasureCode]) REFERENCES [Production].[UnitMeasure] ([UnitMeasureCode])
ALTER TABLE [Production].[Product]
    CHECK CONSTRAINT [FK_Product_UnitMeasure_WeightUnitMeasureCode]

GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key constraint referencing UnitMeasure.UnitMeasureCode.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'CONSTRAINT', N'FK_Product_UnitMeasure_WeightUnitMeasureCode'
GO
CREATE UNIQUE NONCLUSTERED INDEX [AK_Product_Name]
    ON [Production].[Product] ([Name])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unique nonclustered index.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'INDEX', N'AK_Product_Name'
GO
CREATE UNIQUE NONCLUSTERED INDEX [AK_Product_ProductNumber]
    ON [Production].[Product] ([ProductNumber])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unique nonclustered index.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'INDEX', N'AK_Product_ProductNumber'
GO
CREATE UNIQUE NONCLUSTERED INDEX [AK_Product_rowguid]
    ON [Production].[Product] ([rowguid])
    ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unique nonclustered index. Used to support replication samples.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'INDEX', N'AK_Product_rowguid'
GO
EXEC sp_addextendedproperty N'MS_Description', N'H = High, M = Medium, L = Low', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'Class'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Product color.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'Color'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Number of days required to manufacture the product.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'DaysToManufacture'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date the product was discontinued.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'DiscontinuedDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 = Product is not a salable item. 1 = Product is salable.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'FinishedGoodsFlag'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Selling price.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'ListPrice'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 = Product is purchased, 1 = Product is manufactured in-house.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'MakeFlag'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date and time the record was last updated.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'ModifiedDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Name of the product.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'Name'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key for Product records.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'ProductID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'R = Road, M = Mountain, T = Touring, S = Standard', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'ProductLine'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Product is a member of this product model. Foreign key to ProductModel.ProductModelID.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'ProductModelID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unique product identification number.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'ProductNumber'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Product is a member of this product subcategory. Foreign key to ProductSubCategory.ProductSubCategoryID. ', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'ProductSubcategoryID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Inventory level that triggers a purchase order or work order. ', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'ReorderPoint'
GO
EXEC sp_addextendedproperty N'MS_Description', N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'rowguid'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Minimum inventory quantity. ', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'SafetyStockLevel'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date the product was no longer available for sale.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'SellEndDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date the product was available for sale.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'SellStartDate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Product size.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'Size'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unit of measure for Size column.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'SizeUnitMeasureCode'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Standard cost of the product.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'StandardCost'
GO
EXEC sp_addextendedproperty N'MS_Description', N'W = Womens, M = Mens, U = Universal', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'Style'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Product weight.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'Weight'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Unit of measure for Weight column.', 'SCHEMA', N'Production', 'TABLE', N'Product', 'COLUMN', N'WeightUnitMeasureCode'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Products sold or used in the manfacturing of sold products.', 'SCHEMA', N'Production', 'TABLE', N'Product', NULL, NULL
GO

Collapse image See also


List of tables