Properties

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

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    TerritoryID  nvarchar  40           
    TerritoryDescription  nchar  100           
    RegionID  int           
Total: 3 column(s)

Indexes

Index Primary Unique Description
  PK_Territories       
  _WA_Sys_RegionID_35BCFE0A       
Total: 2 index(es)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  dbo.EmployeeTerritories  FK_EmployeeTerritories_Territories  PK_Territories 
Total: 1 table(s)

Referenced Tables

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

Objects that [dbo].[Territories] depends on

Object Name Owner Object Type Dep Level
  Region  dbo  Table 
Total: 1 object(s)

Objects that depend on [dbo].[Territories]

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

SQL

CREATE TABLE [Territories] (
    [TerritoryID] [nvarchar] (20) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [TerritoryDescription] [nchar] (50) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [RegionID] [int] NOT NULL ,
    CONSTRAINT [PK_Territories] PRIMARY KEY  NONCLUSTERED
    (
        [TerritoryID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_Territories_Region] FOREIGN KEY
    (
        [RegionID]
    ) REFERENCES [Region] (
        [RegionID]
    )
) ON [PRIMARY]
GO


See Also

List of tables