-- create a table
CREATE TABLE students (
  id INTEGER PRIMARY KEY,
  name VARCHAR(30) NOT NULL,
  gender CHAR(1) NOT NULL
);
-- insert some values
INSERT INTO students VALUES (1, 'Ryan', 'M');
INSERT INTO students VALUES (2, 'Joanna', 'F');
-- fetch some values
SELECT * FROM students WHERE gender = 'F';

describe students;

alter table students add column contact INTEGER;

describe students;

alter TABLE students
rename column contact to job_code;

describe students;

#truncate TABLE students;

SELECT * from students;

#drop TABLE students;