What is the SQL command that constucts a new table in the \"SALES\" database tha

Question

What is the SQL command that constucts a new table in the "SALES" database that is shown in the image below

What is the SQL command that constructs a new table in the "SALES" database that is shown in the image below Drag the options to the provided blanks to construct the SQL statement. CREATE TABLE INVOICE CONSTRUCT SALES INVOICE SCHEMA PK INV NUMBER INTEGER INV NUMBER INT NOT NULL, CUS CODE STRING (MAX 10 CHAR) TABLE INV DATE DATE PRIMARY KEY (INV NUMBER) SALES DATABASE INVOICE INV DATE DATE, IF NOT EXISTS CUS CODE VARCHAR(10),

Explanation / Answer

Here is the syntax to create a table and the actual query to create an invoice table in the sales database.

Syntax:

Answer:

CREATE TABLE IF NOT EXISTS SALES.INVOICE (INV_NUMBER INT NOT NULL, CUS_CODE VARCHAR(10), INV_DATE DATE, PRIMARY KEY(INV_NUMBER) );

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.