Write an SQL statement which create a new table that is called ORDERS with the following attributes: ORDER_ID, ORDER_DATETIME,…

Write an SQL statement which create a new table that is called ORDERS with the following attributes: ORDER_ID, ORDER_DATETIME,…

Question:

 

Transcribed Image Text:

Write an SQL statement which create a new table that is called “ORDERS” with the following attributes: ORDER_ID, ORDER_DATETIME, CUSTOMER_ID, ORDER_STATUS. Write an SQL statement that will add a primary key constraint called “pk orders”, which adds the ORDER_ID column as the primary key for the newly created table.

Expert Answer:

Answer rating: 100% (QA)

Sure here are the SQL statements to create the ORDERS table and add
View the full answer