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
Post a Comment