General Note: Here we have pulled in the data from a sample database. You can download it from the following link and use it for practicing Click Here For Sample Database

In this tutorial, you will learn the use of DESC keyword in SQLite.

In order to know the structure of table just use the .schema keyword with table name, in other RDBMS the keyword "Describe" is used.


.schema mobile_sales_details

CREATE TABLE mobile_sales_details(mobile_name text primary key,type text,
price integer(10),discount numeric,sold_count int,brand_name text,
os_name text,added_date date,sim_type text,primary_camera_pixel numeric);

The above query will display the create statement of the mobile_sales_details. The .schema is equivalent to DESC keyword in other RDBMS.