Table: Northwind.dbo.CustomerDemographics

Collapse All Expand All

Table Properties

Creation Options

Columns

	Name	Description	Data Type	Max Length	Nullable	Default	IsGUID
	CustomerTypeID		nchar	10
	CustomerDesc		ntext	1073741823

Total: 2 column(s)

Indexes

	Index	Primary	Unique
	PK_CustomerDemographics

Fulltext Index

Statistics

Check Constraints

Identity Column

Referencing Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	CustomerCustomerDemo	FK_CustomerCustomerDemo	PK_CustomerDemographics

Total: 1 table(s)

Referenced Tables

Objects that depend on CustomerDemographics

	Object Name	Object Type	Dep Level
	CustomerCustomerDemo	Table	1

Total 1 object(s)

Objects that CustomerDemographics 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].[CustomerDemographics] (
        [CustomerTypeID]     nchar(10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
        [CustomerDesc]       ntext COLLATE SQL_Latin1_General_CP1_CI_AS NULL
)
ON [PRIMARY]
TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[CustomerDemographics]
    ADD
    CONSTRAINT [PK_CustomerDemographics]
    PRIMARY KEY
    NONCLUSTERED
    ([CustomerTypeID])
    ON [PRIMARY]
GO

See also

Buildmasters.com.au