Properties

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

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    RegionID  int           
    RegionDescription  nchar  100           
Total: 2 column(s)

Indexes

Index Primary Unique Description
  PK_Region       
Total: 1 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  dbo.Territories  FK_Territories_Region  PK_Region 
Total: 1 table(s)

Objects that depend on [dbo].[Region]

Object Name Owner Object Type Dep Level
  Territories  dbo  Table 
  EmployeeTerritories  dbo  Table 
Total: 2 object(s)

SQL

CREATE TABLE [Region] (
    [RegionID] [int] NOT NULL ,
    [RegionDescription] [nchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    CONSTRAINT [PK_Region] PRIMARY KEY  NONCLUSTERED
    (
        [RegionID]
    )  ON [PRIMARY]
) ON [PRIMARY]
GO


See Also

List of tables