Create Buses table program in SQL

 

Question:

Create Buses table

Refer the below schema and create the buses table.

Column Name	Datatype	Size	Constraint	Constraint name
Bus_no	Number	11	Primary key	PK_BUSES
Bus_name	Varchar2	20
Type	Varchar2	20
Total_seats	Number	11
Avail_seats	Number	11

Code:

create table buses(

Bus_no number(11),

  Bus_name varchar2(20),

  Type varchar2(20),

  Total_seats number(11),

  Avail_seats number(30),

  constraint PK_BUSES primary key(Bus_no)

);

• Tweet
• Share
• Share
• Share
• Share

Related Post