(local).Northwind.dbo.Employees

Properties

Name Value
Created 2004-07-20
Rows 9
Data Size KB 232

Columns

Column Type Length Allow Nulls Rule(s)
EmployeeID int 4   .
LastName nvarchar 20   .
FirstName nvarchar 10   .
Title nvarchar 30 Allow Nulls .
TitleOfCourtesy nvarchar 25 Allow Nulls .
BirthDate datetime 8 Allow Nulls .
HireDate datetime 8 Allow Nulls .
Address nvarchar 60 Allow Nulls .
City nvarchar 15 Allow Nulls .
Region nvarchar 15 Allow Nulls .
PostalCode nvarchar 10 Allow Nulls .
Country nvarchar 15 Allow Nulls .
HomePhone nvarchar 24 Allow Nulls .
Extension nvarchar 4 Allow Nulls .
Photo image 16 Allow Nulls .
Notes ntext 16 Allow Nulls .
ReportsTo int 4 Allow Nulls .
PhotoPath nvarchar 255 Allow Nulls .

Checks

Name Expression

(local).Northwind2.dbo.Employees

Properties

Name Value
Created 2004-09-28
Rows 9
Data Size KB 240

Columns

Column Type Length Allow Nulls Rule(s)
EmployeeID int 4   .
LastName nvarchar 20   .
FirstName nvarchar 10   .
Title nvarchar 30 Allow Nulls .
TitleOfCourtesy nvarchar 25 Allow Nulls .
BirthDate datetime 8 Allow Nulls .
HireDate datetime 8 Allow Nulls .
Address nvarchar 60 Allow Nulls .
City nvarchar 15 Allow Nulls .
Region nvarchar 15 Allow Nulls .
PostalCode nvarchar 10 Allow Nulls .
Country nvarchar 15 Allow Nulls .
HomePhone nvarchar 24 Allow Nulls .
Extension nvarchar 4 Allow Nulls .
Photo image 16 Allow Nulls .
Notes ntext 16 Allow Nulls .
ReportsTo int 4 Allow Nulls .
PhotoPath nvarchar 255 Allow Nulls .

Checks

Name Expression

Key

  Different
  Additional

Generated on 28/09/2004 15:51:51 by DataAide.