Chapter 5 Exercise 14

Make a backup copy of the database before attempting this question.

14. Write the SQL CREATE TABLE command to create a new Employee table with no data.

The short way is to copy it from the SQL Server definition file or SQL Server itself.
CREATE TABLE [dbo].[Employee](
[EmployeeID] [int] IDENTITY(1,1) NOT NULL,
[LastName] [nvarchar](100) NULL,
[FirstName] [nvarchar](100) NULL,
[Phone] [nvarchar](100) NULL,
[Address] [nvarchar](100) NULL,
[ZipCode] [nvarchar](100) NULL,
[CityID] [int] NULL,
[TaxPayerID] [nvarchar](50) NULL,
[DateHired] [smalldatetime] NULL,
[DateReleased] [smalldatetime] NULL,
[ManagerID] [int] NULL,
[EmployeeLevel] [int] NULL,
[Title] [nvarchar](50) NULL,
CONSTRAINT [pk_Employee] PRIMARY KEY CLUSTERED
([EmployeeID] ASC)
);