Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create the tables customers and orders with the following columns. (Do not declare the corresponding primary and foreign keys.) customers customerid char(5) not null companyname
Create the tables customers and orders with the following columns. (Do not declare the corresponding primary and foreign keys.) customers customerid char(5) not null companyname varchar(40) not null contactname char(30) null address varchar(60) null city char(15) null phone char(24) null fax char(24) null orders orderid integer not null customerid char(5) not null orderdate date null shippeddate date null freight money null shipname varchar(40) null shipaddress varchar(60) null quantity integer null 5. Using SQL Server Management Studio, try to insert a new row into the orders table with the following values: (10, 'ordoi', getdate(), getdate(), 100.0, 'Windstar', 'Ocean', 1) If it is not working, describe why? 6. Using the ALTER TABLE statement, add the current system date and time as the default value to the orderdate column of the orders table. 7. Using the ALTER TABLE statement, create an integrity constraint that limits the possible values of the quantity column in the orders table to values between 1 and 30. 8. Delete the primary key of the customers table. 9. Rename the city column of the customers table. The new name is town
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started