display all views generated from a table code example

Example 1: mysql show views

SHOW FULL TABLES 
WHERE table_type = 'VIEW';

Example 2: how to see the query of a view in mysql

SHOW FULL TABLES IN sys 
WHERE table_type='VIEW';