Table: Northwind.dbo.Categories

Collapse All Expand All

Table Properties

Creation Options

Columns

		Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
		CategoryID		int	4
		CategoryName		nvarchar	15
		Description		ntext	1073741823
		Picture		image	2147483647

Total: 4 column(s)

Indexes

	Index	Primary	Unique
	PK_Categories
	CategoryName

Fulltext Index

Statistics

Check Constraints

Identity Column

	Name	Seed	Increment	Not for replication
	CategoryID	1	1

Referencing Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	Products	FK_Products_Categories	PK_Categories

Total: 1 table(s)

Referenced Tables

Objects that depend on Categories

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

Total 21 object(s)

Objects that Categories depends on

Column Level Dependencies

Graphical Dependencies

Extended Properties

Permissions

Table Options

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Categories] (
        [CategoryID]       int NOT NULL IDENTITY(1, 1),
        [CategoryName]     nvarchar(15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [Description]      ntext COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
        [Picture]          image NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[Categories]
    ADD
    CONSTRAINT [PK_Categories]
    PRIMARY KEY
    ([CategoryID])
    ON [PRIMARY]
GO
CREATE INDEX [CategoryName]
    ON [dbo].[Categories] ([CategoryName])
    ON [PRIMARY]
GO

See also

Buildmasters.com.au