Quantcast

A community for students. Sign up today!

Here's the question you clicked on:

55 members online
  • 0 replying
  • 0 viewing

shrylitt

  • 3 years ago

What query command would you use to create a table called Products with the following columns? Unique ProductID, Description - up to 100characters, Instock and ModifiedDate

  • This Question is Closed
  1. Sarmadi
    • 3 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    create table Products(ProductID varchar2[10] unique, Description varchar2[100], Instock varchar2[10], ModifiedDate Date);

  2. keketsu
    • 3 years ago
    Best Response
    You've already chosen the best response.
    Medals 0

    I might only add that Instock is probably one of two possibilities, right? Like ('in','out')? You might use an enum for that that instead, if your database supports it. Like ENUM('in','out').

  3. Not the answer you are looking for?
    Search for more explanations.

    • Attachments:

Ask your own question

Ask a Question
Find more explanations on OpenStudy

Your question is ready. Sign up for free to start getting answers.

spraguer (Moderator)
5 → View Detailed Profile

is replying to Can someone tell me what button the professor is hitting...

23

  • Teamwork 19 Teammate
  • Problem Solving 19 Hero
  • You have blocked this person.
  • ✔ You're a fan Checking fan status...

Thanks for being so helpful in mathematics. If you are getting quality help, make sure you spread the word about OpenStudy.

This is the testimonial you wrote.
You haven't written a testimonial for Owlfred.