Owner: Production 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB:
Index Size KB: 40 
Description: High-level product categorization. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    ProductCategoryID  int          Primary key for ProductCategory records. 
    Name  Name  100          Category description. 
    rowguid  uniqueidentifier  16    (newid())      ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 4 column(s)

Identity column

Name Seed Increment Not for replication


Index Primary Unique Description
  PK_ProductCategory_ProductCategoryID      Primary key (clustered) constraint 
  AK_ProductCategory_Name      Unique nonclustered index. 
  AK_ProductCategory_rowguid      Unique nonclustered index. Used to support replication samples. 
Total: 3 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Production.ProductSubcategory  FK_ProductSubcategory_ProductCategory_ProductCategoryID  PK_ProductCategory_ProductCategoryID 
Total: 1 table(s)

Objects that [Production].[ProductCategory] depends on

Object Name Owner Object Type Dep Level
  Name  dbo  User Defined type 
Total: 1 object(s)

Objects that depend on [Production].[ProductCategory]

Object Name Owner Object Type Dep Level
  ProductSubcategory  Production  Table 
  Product  Production  Table 
  vProductAndDescription  Production  View 
  BillOfMaterials  Production  Table 
  ProductCostHistory  Production  Table 
  ProductDocument  Production  Table 
  ProductInventory  Production  Table 
  ProductListPriceHistory  Production  Table 
  ProductProductPhoto  Production  Table 
  ProductReview  Production  Table 
  ProductVendor  Purchasing  Table 
  PurchaseOrderDetail  Purchasing  Table 
  ShoppingCartItem  Sales  Table 
  SpecialOfferProduct  Sales  Table 
  TransactionHistory  Production  Table 
  WorkOrder  Production  Table 
  ufnGetProductDealerPrice  dbo  Function 
  ufnGetProductListPrice  dbo  Function 
  ufnGetProductStandardCost  dbo  Function 
  ufnGetStock  dbo  Function 
  SalesOrderDetail  Sales  Table 
  WorkOrderRouting  Production  Table 
  uspGetBillOfMaterials  dbo  Procedure 
  uspGetWhereUsedProductID  dbo  Procedure 
  iPurchaseOrderDetail  Purchasing  Trigger 
  iWorkOrder  Production  Trigger 
  uPurchaseOrderDetail  Purchasing  Trigger 
  uWorkOrder  Production  Trigger 
  iduSalesOrderDetail  Sales  Trigger 
Total: 29 object(s)


CREATE TABLE [ProductCategory] (
    [ProductCategoryID] [int] IDENTITY (1, 1) NOT NULL ,
    [Name] [Name] NOT NULL ,
    [rowguid]  uniqueidentifier ROWGUIDCOL  NOT NULL CONSTRAINT [DF_ProductCategory_rowguid] DEFAULT (newid()),
    [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_ProductCategory_ModifiedDate] DEFAULT (getdate()),
    CONSTRAINT [PK_ProductCategory_ProductCategoryID] PRIMARY KEY  CLUSTERED
    )  ON [PRIMARY]

See Also

List of tables