Owner: | dbo |
Creation Date: | 08/06/2000 |
Located On: | PRIMARY |
Data Size KB: | 8 |
Index Size KB: | 24 |
Rows: | 53 |
Description: |
Name | Data Type | Length | NULL | Default | IsIdentity | IsGUID | Description | ||
|
TerritoryID | nvarchar | 40 |
|
|
|
|||
|
TerritoryDescription | nchar | 100 |
|
|
|
|||
|
|
RegionID | int | 4 |
|
|
|
Index | Primary | Unique | Description | |
|
PK_Territories |
|
|
|
|
_WA_Sys_RegionID_35BCFE0A |
|
|
Table | Foreign Key | Primary Key or Unique Constraint | |
|
dbo.EmployeeTerritories | FK_EmployeeTerritories_Territories | PK_Territories |
Table | Foreign Key | Primary Key or Unique Constraint | |
|
dbo.Region | FK_Territories_Region | PK_Region |
Objects that [dbo].[Territories] depends on
Object Name | Owner | Object Type | Dep Level | |
|
Region | dbo | Table | 1 |
Objects that depend on [dbo].[Territories]
Object Name | Owner | Object Type | Dep Level | |
|
EmployeeTerritories | dbo | Table | 1 |
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