Products

Table Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
ID	117575457
Located On	PRIMARY
Data Size KB	8 KB
Index Size KB	96 KB
Rows	77

Creation Options

Name	Value
QUOTED_IDENTIFIER	ON
ANSI_NULLS	ON
ANSI_PADDING	ON

Columns

Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
ProductID		int	4
ProductName		nvarchar	40
SupplierID		int	4
CategoryID		int	4
QuantityPerUnit		nvarchar	20
UnitPrice		money	8		(0)
UnitsInStock		smallint	2		(0)
UnitsOnOrder		smallint	2		(0)
ReorderLevel		smallint	2		(0)
Discontinued		bit	1		(0)

Total: 10 column(s)

Indexes

Index	Primary	Unique
PK_Products
CategoriesProducts
CategoryID
ProductName
SupplierID
SuppliersProducts

Fulltext Index

No fulltext index exist

Statistics

No statistics exist

Check Constraints

	Name	Expression
	CK_Products_UnitPrice	([UnitPrice] >= 0)
	CK_ReorderLevel	([ReorderLevel] >= 0)
	CK_UnitsInStock	([UnitsInStock] >= 0)
	CK_UnitsOnOrder	([UnitsOnOrder] >= 0)

Identity Column

	Name	Seed	Increment	Not for replication
	ProductID	1	1

Referencing Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	[Order Details]	FK_Order_Details_Products	PK_Products

Total: 1 table(s)

Referenced Tables

Table	Primary Key or Unique Constraint	Foreign Key
Categories	PK_Categories	FK_Products_Categories
Suppliers	PK_Suppliers	FK_Products_Suppliers

Total: 2 table(s)

Objects that depend on Products

Object Name	Object Type	Dep Level
[Alphabetical list of products]	View	1
[Current Product List]	View	1
CustOrderHist	Procedure	1
CustOrdersDetail	Procedure	1
Invoices	View	1
[Order Details Extended]	View	1
[Order Details]	Table	1
[Product Sales for 1997]	View	1
[Products Above Average Price]	View	1
[Products by Category]	View	1
[Sales by Category]	View	1
SalesByCategory	Procedure	1
[Ten Most Expensive Products]	Procedure	1
[Category Sales for 1997]	View	2
[Order Subtotals]	View	2
[Employee Sales by Country]	Procedure	3
[Sales by Year]	Procedure	3
[Sales Totals by Amount]	View	3
[Summary of Sales by Quarter]	View	3
[Summary of Sales by Year]	View	3

Total 20 object(s)

Objects that Products depends on

Object Name	Object Type	Dep Level
Categories	Table	1
Suppliers	Table	1

Total 2 object(s)

Column Level Dependencies

Object Name	Column	Object Type
Categories	CategoryID	Table
Suppliers	SupplierID	Table

Total 2 column(s)

Graphical Dependencies

Click Here to view Dependencies Graphically

Extended Properties

No extended properties defined

Permissions

No permissions defined

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	0

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Products] (
        [ProductID]           int NOT NULL IDENTITY(1, 1),
        [ProductName]         nvarchar(40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [SupplierID]          int NULL,
        [CategoryID]          int NULL,
        [QuantityPerUnit]     nvarchar(20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [UnitPrice]           money NULL,
        [UnitsInStock]        smallint NULL,
        [UnitsOnOrder]        smallint NULL,
        [ReorderLevel]        smallint NULL,
        [Discontinued]        bit NOT NULL
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Products]
    ADD
    CONSTRAINT [PK_Products]
    PRIMARY KEY
    ([ProductID])
    ON [PRIMARY]
GO
ALTER TABLE [dbo].[Products]
    WITH NOCHECK
    ADD
    CONSTRAINT [CK_Products_UnitPrice]
    CHECK
    ([UnitPrice] >= 0)
GO
ALTER TABLE [dbo].[Products]
CHECK CONSTRAINT [CK_Products_UnitPrice]

GO
ALTER TABLE [dbo].[Products]
    WITH NOCHECK
    ADD
    CONSTRAINT [CK_ReorderLevel]
    CHECK
    ([ReorderLevel] >= 0)
GO
ALTER TABLE [dbo].[Products]
CHECK CONSTRAINT [CK_ReorderLevel]

GO
ALTER TABLE [dbo].[Products]
    WITH NOCHECK
    ADD
    CONSTRAINT [CK_UnitsInStock]
    CHECK
    ([UnitsInStock] >= 0)
GO
ALTER TABLE [dbo].[Products]
CHECK CONSTRAINT [CK_UnitsInStock]

GO
ALTER TABLE [dbo].[Products]
    WITH NOCHECK
    ADD
    CONSTRAINT [CK_UnitsOnOrder]
    CHECK
    ([UnitsOnOrder] >= 0)
GO
ALTER TABLE [dbo].[Products]
CHECK CONSTRAINT [CK_UnitsOnOrder]

GO
ALTER TABLE [dbo].[Products]
    ADD
    CONSTRAINT [DF_Products_Discontinued]
    DEFAULT (0) FOR [Discontinued]
GO
ALTER TABLE [dbo].[Products]
    ADD
    CONSTRAINT [DF_Products_ReorderLevel]
    DEFAULT (0) FOR [ReorderLevel]
GO
ALTER TABLE [dbo].[Products]
    ADD
    CONSTRAINT [DF_Products_UnitPrice]
    DEFAULT (0) FOR [UnitPrice]
GO
ALTER TABLE [dbo].[Products]
    ADD
    CONSTRAINT [DF_Products_UnitsInStock]
    DEFAULT (0) FOR [UnitsInStock]
GO
ALTER TABLE [dbo].[Products]
    ADD
    CONSTRAINT [DF_Products_UnitsOnOrder]
    DEFAULT (0) FOR [UnitsOnOrder]
GO
ALTER TABLE [dbo].[Products]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Products_Categories]
    FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[Categories] ([CategoryID])
ALTER TABLE [dbo].[Products]
    CHECK CONSTRAINT [FK_Products_Categories]

GO
ALTER TABLE [dbo].[Products]
    WITH NOCHECK
    ADD CONSTRAINT [FK_Products_Suppliers]
    FOREIGN KEY ([SupplierID]) REFERENCES [dbo].[Suppliers] ([SupplierID])
ALTER TABLE [dbo].[Products]
    CHECK CONSTRAINT [FK_Products_Suppliers]

GO
CREATE INDEX [CategoriesProducts]
    ON [dbo].[Products] ([CategoryID])
    ON [PRIMARY]
GO
CREATE INDEX [CategoryID]
    ON [dbo].[Products] ([CategoryID])
    ON [PRIMARY]
GO
CREATE INDEX [ProductName]
    ON [dbo].[Products] ([ProductName])
    ON [PRIMARY]
GO
CREATE INDEX [SupplierID]
    ON [dbo].[Products] ([SupplierID])
    ON [PRIMARY]
GO
CREATE INDEX [SuppliersProducts]
    ON [dbo].[Products] ([SupplierID])
    ON [PRIMARY]
GO