What is the query for creating the PRODUCT table which contains the following fields: ID (primary key), NAME (product name) and PRICE (the product’s unit price)

Question

Accepted Answer

CREATE TABLE PRODUCT (ID INT PRIMARY KEY, NAME VARCHAR(50), PRICE NUMERIC(6,2))

Answer

CREATE TABLE PRODUCT (ID INT, NAME VARCHAR(50), PRICE INT)

Answer

CREATE TABLE PRODUCT (ID INT PRIMARY KEY, NAME VARCHAR(50), PRICE)

Answer

CREATE TABLE PRODUCT (ID INT NOT NULL, NAME TEXT, PRICE NUMERIC(6,2))

Answer

CREATE TABLE PRODUCT (ID PRIMARY KEY, NAME VARCHAR(50), PRICE NUMERIC(6,2))

Crowdly

What is the query for creating the PRODUCT table which contains the following fi...

Want instant access to all verified answers on softserve.academy?