Properties

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

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    EmployeeID  int           
    TerritoryID  nvarchar  40           
Total: 2 column(s)

Indexes

Index Primary Unique Description
  PK_EmployeeTerritories       
  _WA_Sys_TerritoryID_36B12243       
Total: 2 index(es)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  dbo.Employees  FK_EmployeeTerritories_Employees  PK_Employees 
  dbo.Territories  FK_EmployeeTerritories_Territories  PK_Territories 
Total: 2 table(s)

Objects that [dbo].[EmployeeTerritories] depends on

Object Name Owner Object Type Dep Level
  Employees  dbo  Table 
  Region  dbo  Table 
  Territories  dbo  Table 
Total: 3 object(s)

SQL

CREATE TABLE [EmployeeTerritories] (
    [EmployeeID] [int] NOT NULL ,
    [TerritoryID] [nvarchar] (20) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    CONSTRAINT [PK_EmployeeTerritories] PRIMARY KEY  NONCLUSTERED
    (
        [EmployeeID],
        [TerritoryID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_EmployeeTerritories_Employees] FOREIGN KEY
    (
        [EmployeeID]
    ) REFERENCES [Employees] (
        [EmployeeID]
    ),
    CONSTRAINT [FK_EmployeeTerritories_Territories] FOREIGN KEY
    (
        [TerritoryID]
    ) REFERENCES [Territories] (
        [TerritoryID]
    )
) ON [PRIMARY]
GO


See Also

List of tables