Database : Northwind
Report created by EasyStruct 4.5 on 8/16/2004
  Tables   Views   Stored Procedures   Indexes
  Tables


Region Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
 RegionID 1 No int 10
RegionDescription 2 No nchar 50



PK_Region Top
Name PK_Region
Table Name Region
Index Type Non-Clustered
Unique False
Index FillFactor 0
Primary Key True
Ignore Duplicate Row False



PK_Region - Columns Top
Column Name Sort Order
RegionID Ascending
Tables Views Stored Procedures Indexes


Territories Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
 TerritoryID 1 No nvarchar 20
TerritoryDescription 2 No nchar 50
RegionID 3 No int 10



Territories Top
Name Primary Key Table Foreign Key Table Foreign Key Column Update Rule Delete Rule Primary Key Column
FK_Territories_Region Region Territories RegionID NO ACTION NO ACTION RegionID



PK_Territories Top
Name PK_Territories
Table Name Territories
Index Type Non-Clustered
Unique False
Index FillFactor 0
Primary Key True
Ignore Duplicate Row False



PK_Territories - Columns Top
Column Name Sort Order
TerritoryID Ascending
Tables Views Stored Procedures Indexes


_WA_Sys_RegionID_35BCFE0A Top
Name _WA_Sys_RegionID_35BCFE0A
Table Name Territories
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



_WA_Sys_RegionID_35BCFE0A - Columns Top
Column Name Sort Order
RegionID Ascending
Tables Views Stored Procedures Indexes


EmployeeTerritories Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
 EmployeeID 1 No int 10
 TerritoryID 2 No nvarchar 20



EmployeeTerritories Top
Name Primary Key Table Foreign Key Table Foreign Key Column Update Rule Delete Rule Primary Key Column
FK_EmployeeTerritories_Employees Employees EmployeeTerritories EmployeeID NO ACTION NO ACTION EmployeeID
FK_EmployeeTerritories_Territories Territories EmployeeTerritories TerritoryID NO ACTION NO ACTION TerritoryID



PK_EmployeeTerritories Top
Name PK_EmployeeTerritories
Table Name EmployeeTerritories
Index Type Non-Clustered
Unique False
Index FillFactor 0
Primary Key True
Ignore Duplicate Row False



PK_EmployeeTerritories - Columns Top
Column Name Sort Order
EmployeeID Ascending
TerritoryID Ascending
Tables Views Stored Procedures Indexes


_WA_Sys_TerritoryID_36B12243 Top
Name _WA_Sys_TerritoryID_36B12243
Table Name EmployeeTerritories
Index Type Non-Clustered
Unique True
Index FillFactor 0
Primary Key False
Ignore Duplicate Row False



_WA_Sys_TerritoryID_36B12243 - Columns Top
Column Name Sort Order
TerritoryID Ascending
Tables Views Stored Procedures Indexes


Testing Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
myid 1 No int 10
categoryname 2 No nvarchar 15
priority 3 (0) No int 10
checking Top
Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description
testid 1 No int 10
categoryname 2 No nvarchar 15