CREATE TABLE contacts ( first_name text NOT NULL, last_name text NOT NULL, email text NOT NULL );
CREATE UNIQUE INDEX idx_contacts_email ON contacts (email);
INSERT INTO contacts (first_name, last_name, email)
VALUES
(
'John',
'Doe',
'[email protected]'
);
INSERT INTO contacts (first_name, last_name, email)
VALUES
(
'Johny',
'Doe',
'[email protected]'
);
INSERT INTO contacts (first_name, last_name, email) VALUES ( 'David', 'Brown', '[email protected]' ), ( 'Lisa', 'Smith', '[email protected]' );
SELECT
first_name,
last_name,
email
FROM
contacts
WHERE
email = '[email protected]';
CREATE INDEX idx_contacts_name ON contacts (first_name, last_name);
DROP INDEX idx_contacts_name;
SELECT * FROM albums;
SELECT * FROM artists;
SELECT * FROM customers;
SELECT * FROM employees;
SELECT * FROM genres;
SELECT * FROM invoice_items;
SELECT * FROM invoices;
SELECT * FROM media_types;
SELECT * FROM playlist_track;
SELECT * FROM playlists;
SELECT * FROM tracks;