Answers for "show all views in current databse mysql"

SQL
1

mysql show views

SHOW FULL TABLES 
WHERE table_type = 'VIEW';
Posted by: Guest on November-03-2020
0

mysql show views

SELECT * 
FROM information_schema.tables;
Posted by: Guest on November-03-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language