CREATE VIEW customerPayments AS SELECT customerName, checkNumber, paymentDate, amount FROM customers INNER JOIN payments USING (customerNumber);
SHOW FULL TABLES WHERE table_type = 'VIEW';
views in mysql
SELECT * FROM information_schema.tables;