Check out example codes for "mysql show views". It will help you in understanding the concepts better.

Code Example 1

SELECT * 
FROM information_schema.tables;

Code Example 2

SHOW FULL TABLES 
WHERE table_type = 'VIEW';

Learn ReactJs, React Native from akashmittal.com