Scribd
Upload
5 views

Create Table route

The document outlines the creation of a database table named 'route_header' with various fields including Route_id, ROUTE_no, Cat_code, Origin, Destination, Fare, Distance, and Capacity. It specifies the data types for each field, such as int, Varchar, and decimal. Additionally, there is a SQL command to select all records from the 'route_header' table.

Uploaded by

Karthik Nadar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views

Create Table route

The document outlines the creation of a database table named 'route_header' with various fields including Route_id, ROUTE_no, Cat_code, Origin, Destination, Fare, Distance, and Capacity. It specifies the data types for each field, such as int, Varchar, and decimal. Additionally, there is a SQL command to select all records from the 'route_header' table.

Uploaded by

Karthik Nadar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Create Table route_header(

Route_id int,
ROUTE_no int,
Cat_code int,
Origin Varchar(20),
Destination Varchar(20),
Fare decimal(7,2),
Distance int,
Capacity int
);
select * from route_header

You might also like