Question

1) Write SQL command to create
above Table
2) Write SQL command to insert
above mentioned record in table
3) To delete above table.
​

Answer 1

Answer:

answer is in the attachment

Explanation:

Answer 2

1)

$\tt Create\ database$ Stationery;

$\tt Use$ Stationery;

$\tt Create\ table$ Stationery(S_ID $\tt ch ar$(3), S_Name $\tt varchar$(20), C_Name $\tt ch ar$(3), Price $\tt varchar$(5), Quantity $\tt i nt$);

2)

$\tt Insert\ into$ Stationery $\tt values$("001", "Notebook", "ABC", "20", "50");

$\tt Insert\ into$ Stationery $\tt values$("002", "Pencil Box", "XYZ", "10", "80");

$\tt Insert\ into$ Stationery $\tt values$("003", "A4 Pages rim", "PQR", "600", "2");

$\tt Select$ * $\tt from$ Stationery;

3)

$\tt Drop\ table$ Stationery;