Answered! 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 constucts a new table in the “SALES” database that is shown in the image below

Don't use plagiarized sources. Get Your Custom Essay on

GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE

Order Essay

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),

Expert Answer

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

Syntax:

CREATE TABLE table_name(
   column1 datatype,
   column2 datatype,
   column3 datatype,
   PRIMARY KEY( column1 )
);

Answer:

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

Still stressed from student homework?

Get quality assistance from academic writers!

Order now