Before you can store anything you need a table with named, typed columns. CREATE TABLE defines that structure and DROP TABLE removes the table and all its data for good. Use them when setting up a schema or cleaning up a test table. To remove only the rows and keep the table, use DELETE or TRUNCATE instead, a difference interviewers like to ask about.