Write a single SQL statement to create a new table called ProductHistory with the following column specifications:
Fantastic news! We've Found the answer you've been seeking!
Question:
- Write a single SQL statement to create a new table called ProductHistory with the following column specifications:
- You need to set a primary key and a foreign key for the table. Add a primary key constraint based on both the ProductID and EntryDate columns. Add a foreign key constraint based on the ProductID columns of both ProductHistory and Product tables
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: