SQLite Editor

Examples
Sample Database

CREATE TABLE devices (
	name text NOT NULL,
	model text NOT NULL,
	serial integer NOT NULL UNIQUE
);

INSERT INTO devices (name, model, serial)
VALUES
	(
		'HP ZBook 17 G3 Mobile Workstation',
		'ZBook',
		'SN-2015'
	);

ALTER TABLE devices
RENAME TO equipment;

SELECT
	name,
	model,
	serial
FROM
	equipment;

ALTER TABLE equipment 
ADD COLUMN location text;

albums artists customers employees genres invoice_items invoices media_types playlist_track playlists tracks

Dark Mode

SQL Query

Enter a query, then click the execute button or press F9 to run it.

Result