Computer Science, asked by joshimamta427, 8 months ago

(a) Write a Query to create a Table with the following structure
Table Product
Field
PID
Pname
Description
Price
Datatype
Char(4)
Varchar(20)
Varchar(40)
Decimal​

Answers

Answered by Anjali1011n
73

Answer: Please refer the attachment : )

Having IT (402) CBSE BOARDS tommorow......

Same here....

Hope it helps you...☺️

Please mark brainlist ; )

Attachments:
Answered by yoodyannapolis
14

Create table Product ( PID Char (4), Pname Varchar (20) ,Description Varchar (40) ,Price Decimal (4,2) );

Explanation :

  • Create query is used for creating the table in the database .The create query create a schema of the  database management system .Create command is under the data definition language .
  • To crated any table in the database we used foolowing syntax of create query.
  • Create table tablename(value1 datatype(size),value2 datatype(size)........valuen datatype(size))

Learn More:

https://brainly.in/question/5540764

Similar questions