Sunday, 6 October 2013

07. Create a table named Recipient in the NarrowFabrics database to store the details of the recipients to whom the orders are dispatched. The following table provides the structure of the Recipient table.
















create table Recipient
(
Ordernumber char(6),
FirstName varchar(20),
lastname varchar(20),
Address varchar(50),
City char(15),
state char(15),
CountryCode char(3),
ZipCode char(10),
phone char(15)
)

No comments:

Post a Comment