(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
73
Answer: Please refer the attachment : )
Having IT (402) CBSE BOARDS tommorow......
Same here....
Hope it helps you...☺️
Please mark brainlist ; )
Attachments:
Answered by
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
Computer Science,
5 months ago
Political Science,
5 months ago
Biology,
5 months ago
Math,
11 months ago
Science,
1 year ago