Properties

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

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	1

Total: 1 object(s)

Objects that depend on [dbo].[Territories]

	Object Name	Owner	Object Type	Dep Level
	EmployeeTerritories	dbo	Table	1

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