Drop table in a database using drop statement.

 Drop table in a database using drop statement.

-- create a table DDL

CREATE TABLE students (

  id INTEGER primary key,

  name TEXT ,

  gender TEXT

);


-- insert some values

INSERT INTO students VALUES (1, 'Ryan', 'M');

INSERT INTO students VALUES (2, 'Joanna', 'F');


Drop table students;

SELECT id, student_name, gender  FROM students;


Error: near line 13: no such table: students



Comments