Write SQL statements that will: 1. Create a table named Flavors with columns ItemCode (int), ItemDesc (varchar), and Price (float). 2. Set ItemCode as the primary key. 3. Add a CHECK constraint on the...

Write SQL statements that will:<br>1. Create a table named Flavors with columns ItemCode (int),<br>ItemDesc (varchar), and Price (float).<br>2. Set ItemCode as the primary key.<br>3. Add a CHECK constraint on the Price column to ensure that<br>the lowest price is 65.<br>4. Delete the ItemDesc column.<br>

Extracted text: Write SQL statements that will: 1. Create a table named Flavors with columns ItemCode (int), ItemDesc (varchar), and Price (float). 2. Set ItemCode as the primary key. 3. Add a CHECK constraint on the Price column to ensure that the lowest price is 65. 4. Delete the ItemDesc column.

Jun 08, 2022

SOLUTION.PDF

Write SQL statements that will: 1. Create a table named Flavors with columns ItemCode (int), ItemDesc (varchar), and Price (float). 2. Set ItemCode as the primary key. 3. Add a CHECK constraint on the...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment