Maharashtra State BoardHSC Science (General) 11th
Advertisement Remove all ads

Consider the following table Stationary. Write SQL commands for following statement. Write SQL command to create above Table - Information Technology

Answer in Brief

Consider the following table Stationary. Write SQL commands for following statement.

S_ID S_Name C_Name Price Quantity
001 Note Book ABC 20 50
002 Pencil Box XYZ 10 80
003 A4 Pages rim PQR 600 2

Write SQL command to create above Table

Advertisement Remove all ads

Solution

Create table Stationary (
S_ID int primary key,
S_Name varchar (20),
C_Name varchar (20),
Price smallint,
Quantity smallint
);
Concept: Data Definition Language (DDL) Commands
  Is there an error in this question or solution?
Advertisement Remove all ads

APPEARS IN

Balbharati Information Technology (IT) 11th Standard HSC Maharashtra State Board
Chapter 2 Introduction to DBMS
Exercise | Q 5.1 | Page 29
Advertisement Remove all ads
Advertisement Remove all ads
Share
Notifications

View all notifications


      Forgot password?
View in app×