Database : Northwind
		Report created by EasyStruct 4.5 on 8/16/2004

Tables

Views

Stored Procedures

Indexes

Tables

Employees Top Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description  EmployeeID 1 No int 10 LastName 2 No nvarchar 20 FirstName 3 No nvarchar 10 Title 4 YES nvarchar 30 TitleOfCourtesy 5 YES nvarchar 25 BirthDate 6 YES datetime 23 HireDate 7 YES datetime 23 Address 8 YES nvarchar 60 City 9 YES nvarchar 15 Region 10 YES nvarchar 15 PostalCode 11 YES nvarchar 10 Country 12 YES nvarchar 15 HomePhone 13 YES nvarchar 24 Extension 14 YES nvarchar 4 Photo 15 YES image 2147483647 Notes 16 YES ntext 1073741823 ReportsTo 17 YES int 10 PhotoPath 18 YES nvarchar 255 Employees Top Name Primary Key Table Foreign Key Table Foreign Key Column Update Rule Delete Rule Primary Key Column FK_Employees_Employees Employees Employees ReportsTo NO ACTION NO ACTION EmployeeID PK_Employees Top Name PK_Employees Table Name Employees Index Type Clustered Unique False Index FillFactor 0 Primary Key True Ignore Duplicate Row False PK_Employees - Columns Top Column Name Sort Order EmployeeID Ascending Tables Views Stored Procedures Indexes LastName Top Name LastName Table Name Employees Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False LastName - Columns Top Column Name Sort Order LastName Ascending Tables Views Stored Procedures Indexes PostalCode Top Name PostalCode Table Name Employees Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False PostalCode - Columns Top Column Name Sort Order PostalCode Ascending Tables Views Stored Procedures Indexes tEmployees Top Name tEmployees Table Name Employees Index Type Non-Clustered Unique False Index FillFactor 0 Primary Key False Ignore Duplicate Row False Categories Top Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description  CategoryID 1 No int 10 CategoryName 2 No nvarchar 15 Description 3 YES ntext 1073741823 Picture 4 YES image 2147483647 PK_Categories Top Name PK_Categories Table Name Categories Index Type Clustered Unique False Index FillFactor 0 Primary Key True Ignore Duplicate Row False PK_Categories - Columns Top Column Name Sort Order CategoryID Ascending Tables Views Stored Procedures Indexes CategoryName Top Name CategoryName Table Name Categories Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False CategoryName - Columns Top Column Name Sort Order CategoryName Ascending Tables Views Stored Procedures Indexes tCategories Top Name tCategories Table Name Categories Index Type Non-Clustered Unique False Index FillFactor 0 Primary Key False Ignore Duplicate Row False Customers Top Column Name Ordinal Position Default Value Null Allowed Data Type Precision Check Clause Description  CustomerID 1 No nchar 5 CompanyName 2 No nvarchar 40 ContactName 3 YES nvarchar 30 ContactTitle 4 YES nvarchar 30 Address 5 YES nvarchar 60 City 6 YES nvarchar 15 Region 7 YES nvarchar 15 PostalCode 8 YES nvarchar 10 Country 9 YES nvarchar 15 Phone 10 YES nvarchar 24 Fax 11 YES nvarchar 24 PK_Customers Top Name PK_Customers Table Name Customers Index Type Clustered Unique False Index FillFactor 0 Primary Key True Ignore Duplicate Row False PK_Customers - Columns Top Column Name Sort Order CustomerID Ascending Tables Views Stored Procedures Indexes City Top Name City Table Name Customers Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False City - Columns Top Column Name Sort Order City Ascending Tables Views Stored Procedures Indexes CompanyName Top Name CompanyName Table Name Customers Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False CompanyName - Columns Top Column Name Sort Order CompanyName Ascending Tables Views Stored Procedures Indexes PostalCode Top Name PostalCode Table Name Customers Index Type Non-Clustered Unique True Index FillFactor 0 Primary Key False Ignore Duplicate Row False PostalCode - Columns Top Column Name Sort Order PostalCode