Properties

Owner: dbo 
Creation Date: 08/06/2000 
Located On: PRIMARY 
Data Size KB: 232 
Index Size KB: 48 
Rows:
Description:  

Columns

Name Data Type Length NULL Default IsIdentity IsGUID Description
    EmployeeID  int           
    LastName  nvarchar  40           
    FirstName  nvarchar  20           
    Title  nvarchar  60           
    TitleOfCourtesy  nvarchar  50           
    BirthDate  datetime           
    HireDate  datetime           
    Address  nvarchar  120           
    City  nvarchar  30           
    Region  nvarchar  30           
    PostalCode  nvarchar  20           
    Country  nvarchar  30           
    HomePhone  nvarchar  48           
    Extension  nvarchar           
    Photo  image  16           
    Notes  ntext  16           
    ReportsTo  int           
    PhotoPath  nvarchar  510           
Total: 18 column(s)

Identity column

Name Seed Increment Not for replication
  EmployeeID   

Indexes

Index Primary Unique Description
  PK_Employees       
  LastName       
  PostalCode       
Total: 3 index(es)

Check Constraints

Name Expression
  CK_Birthdate  ([BirthDate] < getdate()) 
Total: 1 constraint(s)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  dbo.Orders  FK_Orders_Employees  PK_Employees 
  dbo.EmployeeTerritories  FK_EmployeeTerritories_Employees  PK_Employees 
  dbo.Employees  FK_Employees_Employees  PK_Employees 
Total: 3 table(s)

Referenced Tables

Table Foreign Key Primary Key or Unique Constraint
  dbo.Employees  FK_Employees_Employees  PK_Employees 
Total: 1 table(s)

Objects that depend on [dbo].[Employees]

Object Name Owner Object Type Dep Level
  EmployeeTerritories  dbo  Table 
  Orders  dbo  Table 
  Orders Qry  dbo  View 
  Quarterly Orders  dbo  View 
  Order Details  dbo  Table 
  CustOrdersOrders  dbo  Procedure 
  Invoices  dbo  View 
  Order Details Extended  dbo  View 
  Order Subtotals  dbo  View 
  Product Sales for 1997  dbo  View 
  CustOrderHist  dbo  Procedure 
  CustOrdersDetail  dbo  Procedure 
  SalesByCategory  dbo  Procedure 
  Category Sales for 1997  dbo  View 
  Sales by Category  dbo  View 
  Sales Totals by Amount  dbo  View 
  Summary of Sales by Quarter  dbo  View 
  Summary of Sales by Year  dbo  View 
  Employee Sales by Country  dbo  Procedure 
  Sales by Year  dbo  Procedure 
Total: 20 object(s)

SQL

CREATE TABLE [Employees] (
    [EmployeeID] [int] IDENTITY (1, 1) NOT NULL ,
    [LastName] [nvarchar] (20) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [FirstName] [nvarchar] (10) COLLATE Cyrillic_General_CI_AS NOT NULL ,
    [Title] [nvarchar] (30) COLLATE Cyrillic_General_CI_AS NULL ,
    [TitleOfCourtesy] [nvarchar] (25) COLLATE Cyrillic_General_CI_AS NULL ,
    [BirthDate] [datetime] NULL ,
    [HireDate] [datetime] NULL ,
    [Address] [nvarchar] (60) COLLATE Cyrillic_General_CI_AS NULL ,
    [City] [nvarchar] (15) COLLATE Cyrillic_General_CI_AS NULL ,
    [Region] [nvarchar] (15) COLLATE Cyrillic_General_CI_AS NULL ,
    [PostalCode] [nvarchar] (10) COLLATE Cyrillic_General_CI_AS NULL ,
    [Country] [nvarchar] (15) COLLATE Cyrillic_General_CI_AS NULL ,
    [HomePhone] [nvarchar] (24) COLLATE Cyrillic_General_CI_AS NULL ,
    [Extension] [nvarchar] (4) COLLATE Cyrillic_General_CI_AS NULL ,
    [Photo] [image] NULL ,
    [Notes] [ntext] COLLATE Cyrillic_General_CI_AS NULL ,
    [ReportsTo] [int] NULL ,
    [PhotoPath] [nvarchar] (255) COLLATE Cyrillic_General_CI_AS NULL ,
    CONSTRAINT [PK_Employees] PRIMARY KEY  CLUSTERED
    (
        [EmployeeID]
    )  ON [PRIMARY] ,
    CONSTRAINT [FK_Employees_Employees] FOREIGN KEY
    (
        [ReportsTo]
    ) REFERENCES [Employees] (
        [EmployeeID]
    ),
    CONSTRAINT [CK_Birthdate] CHECK ([BirthDate] < getdate())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


See Also

List of tables