Properties

Owner: dbo 
Creation Date: 08/06/2000 
Located On: PRIMARY 
Data Size KB:
Index Size KB:
Rows:
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 
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