Fewpal
0 votes
93 views
in Information Technology by (47.6k points)
closed by

Write SQL query to create a table Inventory with the following structure :

FieldTypeConstraint
MaterialldIntegerPrimary key
MaterialVarcher(50)NOT NULL
CategoryChar
DatePurchaseDate

1 Answer

0 votes
by (52.3k points)
selected by
 
Best answer

CREATE TABLE Inventory 

Material Id Integer Primary Key, 

Material Varchar (50) NOT NULL, 

Category Char, 

DatePurchase Date 

) :

Related questions

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...