andersr · December 23, 2015 21:49
diff --git a/SQL Command 1: Create Table artists b/SQL Command 1: Create Table artists
 CREATE TABLE artists(
  name TEXT,
  age INTEGER,
  instruments TEXT,
  songs TEXT,
  genres TEXT
 );
diff --git a/SQL Command 2: Add Albums to Artists b/SQL Command 2: Add Albums to Artists
 ALTER TABLE artists ADD COLUMN albums TEXT;
diff --git a/SQL Command 3: Rename Artists table to Musicians b/SQL Command 3: Rename Artists table to Musicians
 ALTER TABLE artists RENAME TO musicians;
diff --git a/SQL Command 4: Drop table musicians b/SQL Command 4: Drop table musicians
 DROP TABLE musicians;
	CREATE TABLE artists(
	name TEXT,
	age INTEGER,
	instruments TEXT,
	songs TEXT,
	genres TEXT
	);
No results found