What is a View?
A view is a saved SELECT query that behaves like a read-only virtual table. Useful for reusing complex joins or filtering.
Create — click + Create View, give it a name and a SELECT statement.
Example: SELECT id, name FROM users WHERE active = 1
Edit / Modify — SQLite doesn't support ALTER VIEW. Click ✏ Edit to drop and recreate with new SQL.
Drop — permanently removes the view (data is unaffected — views don't store data).
Browse data — click the view name in the sidebar to browse its rows in the Data tab.
👁
Select a database to see views
⚡ Triggers
What is a Trigger?
A trigger automatically runs SQL when a row is inserted, updated, or deleted in a table.
Timing:BEFORE or AFTER the event. Events:INSERT, UPDATE, DELETE Special values:NEW.col = incoming value, OLD.col = previous value
Example — auto-set updated_at: CREATE TRIGGER set_updated_at
AFTER UPDATE ON users
BEGIN
UPDATE users SET updated_at = datetime('now')
WHERE id = NEW.id;
END; Example — prevent delete: CREATE TRIGGER no_delete_admin
BEFORE DELETE ON users
WHEN OLD.role = 'admin'
BEGIN
SELECT RAISE(ABORT, 'Cannot delete admin');
END; Edit / Modify — SQLite doesn't support ALTER TRIGGER. Click ✏ Edit to drop and recreate. Drop — removes the trigger only; data is unaffected.
⚡
Select a database to see triggers
🔍 Advanced Search
Advanced Search lets you build multi-condition queries without writing SQL.
Operators: = exact match | != not equal | < > <= >= numeric compare |
LIKE pattern (use % wildcard, e.g. %smith%) |
IS NULL / IS NOT NULL empty check |
IN comma-separated list (e.g. 1,2,5)
AND / OR — combine all conditions with AND (all must match) or OR (any must match).