Properties

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

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		ProductCategoryID	int	4					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	8		(getdate())			Date and time the record was last updated.

Total: 4 column(s)

Identity column

	Name	Seed	Increment	Not for replication
	ProductCategoryID	1	1

Indexes

	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	1

Total: 1 object(s)

Objects that depend on [Production].[ProductCategory]

	Object Name	Owner	Object Type	Dep Level
	ProductSubcategory	Production	Table	1
	Product	Production	Table	2
	vProductAndDescription	Production	View	3
	BillOfMaterials	Production	Table	3
	ProductCostHistory	Production	Table	3
	ProductDocument	Production	Table	3
	ProductInventory	Production	Table	3
	ProductListPriceHistory	Production	Table	3
	ProductProductPhoto	Production	Table	3
	ProductReview	Production	Table	3
	ProductVendor	Purchasing	Table	3
	PurchaseOrderDetail	Purchasing	Table	3
	ShoppingCartItem	Sales	Table	3
	SpecialOfferProduct	Sales	Table	3
	TransactionHistory	Production	Table	3
	WorkOrder	Production	Table	3
	ufnGetProductDealerPrice	dbo	Function	4
	ufnGetProductListPrice	dbo	Function	4
	ufnGetProductStandardCost	dbo	Function	4
	ufnGetStock	dbo	Function	4
	SalesOrderDetail	Sales	Table	4
	WorkOrderRouting	Production	Table	4
	uspGetBillOfMaterials	dbo	Procedure	4
	uspGetWhereUsedProductID	dbo	Procedure	4
	iPurchaseOrderDetail	Purchasing	Trigger	4
	iWorkOrder	Production	Trigger	4
	uPurchaseOrderDetail	Purchasing	Trigger	4
	uWorkOrder	Production	Trigger	4
	iduSalesOrderDetail	Sales	Trigger	5

Total: 29 object(s)

SQL

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
    (
        [ProductCategoryID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO

See Also

List of tables