Database Tables  «Prev  Next»

Create SQL Server Table - Exercise Result

Creating a table

Objective: Create a table that includes 5 columns.

Exercise Scoring

This exercise is worth a total of 10 points. You will receive up to 10 points for accurately creating the table as described in the instructions.

Instructions

Create a table to store inventory data, named Inventory, which includes these columns:
  1. StockNum
  2. Cost
  3. RetailPrice
  4. QtyAvailable
  5. LastPriceChangeDate
When creating the table, use only datatypes Int, SmallMoney, SmallDateTime. Use your judgement as to which datatype is to be associated to a specific column.

Submitting the exercise

Type or paste your statements into the text box below, then click the Submit button to submit them to the course tutor and view a results page.