Database Tables  «Prev  Next»

Create SQL Server Table - Exercise

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 the int, smallmoney, and smalldatetime datatypes. Use your own judgment as to which datatype best fits each column.


Submitting the Exercise

Type or paste your statement into the text box above, then click the Submit button to submit it and view a results page.