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

This note was uploaded on 09/21/2011 for the course CGS 2545 taught by Professor Markllewellyn during the Summer '10 term at University of Central Florida.

Ask a homework question - tutors are online