Query

interns.db — intern

SQL

CREATE TABLE "intern"  (
  "first"	TEXT,
  "last"	TEXT,
  "school"	TEXT,
  "phone"	TEXT,
  "email"	TEXT,
  "parent_first"	TEXT,
  "parent_lat"	TEXT,
  "parent_email"	TEXT,
  "parent_phone"	TEXT,
  "project_description" TEXT
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
first TEXT ✓ Rename | Drop
last TEXT ✓ Rename | Drop
school TEXT ✓ Rename | Drop
phone TEXT ✓ Rename | Drop
email TEXT ✓ Rename | Drop
parent_first TEXT ✓ Rename | Drop
parent_lat TEXT ✓ Rename | Drop
parent_email TEXT ✓ Rename | Drop
parent_phone TEXT ✓ Rename | Drop
project_description TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?