Properties

Owner:	dbo
Creation Date:	08/06/2000
Located On:	PRIMARY
Data Size KB:	0
Index Size KB:	0
Rows:	0
Description:

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		CustomerTypeID	nchar	20
		CustomerDesc	ntext	16

Total: 2 column(s)

Indexes

	Index	Primary	Unique	Description
	PK_CustomerDemographics

Total: 1 index(es)

Referencing Tables

	Table	Foreign Key	Primary Key or Unique Constraint
	dbo.CustomerCustomerDemo	FK_CustomerCustomerDemo	PK_CustomerDemographics

Total: 1 table(s)

Objects that depend on [dbo].[CustomerDemographics]

	Object Name	Owner	Object Type	Dep Level
	CustomerCustomerDemo	dbo	Table	1

Total: 1 object(s)

SQL

CREATE TABLE [CustomerDemographics] (
    [CustomerTypeID] [nchar] (10) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [CustomerDesc] [ntext] COLLATE Cyrillic_General_CI_AS NULL ,
    CONSTRAINT [PK_CustomerDemographics] PRIMARY KEY  NONCLUSTERED
    (
        [CustomerTypeID]
    )  ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

See Also

List of tables