Assignment 6 - CustomerZipCode nchar (5) NOT NULL,...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Kristina Lister CGS 2545 00:00:22 Assignment 6 CREATE TABLEdbo.Customer (Customer ID int (1000) PRIMARY KEY, CustomerLastName nvarchar (20) NOT NULL, CustomerFirstName nvarchar (20) NOT NULL, CustomerStreet nvarchar(50) NOT NULL, CustomerCity nvarchar(30) NOT NULL, CustomerState nchar (5) NOT NULL,
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CustomerZipCode nchar (5) NOT NULL, CustomerCreditLimit nchar (5) NOT NULL, CustomerCurrentBalance nchar (5) NOT NULL, CallFromCustomerID int(1000) REFERENCES dbo.CallInformation SaleId nchar (10) REFERENCES dbo.Sale(SaleId))...
View Full Document

Ask a homework question - tutors are online