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