CREATE DATABASE [NorthwindCopy]  ON (NAME = N'NorthwindCopy_Data', FILENAME = N'C:\Applications\Microsoft SQL Server\MSSQL\data\NorthwindCopy_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'NorthwindCopy_Log', FILENAME = N'C:\Applications\Microsoft SQL Server\MSSQL\data\NorthwindCopy_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
 COLLATE SQL_Latin1_General_CP1_CI_AS
GO


use [NorthwindCopy]
GO

CREATE TABLE [dbo].[CustomersShort] (
	[ID] [nchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Company] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Contact] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

