How to get a list of MySQL views?

by 
SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW';

MySQL query to find all views in a database

More Related Contents:

  1. MySQL: How do I use delimiters in triggers?
  2. MySQL remove all whitespaces from the entire column
  3. True/False vs 0/1 in MySQL
  4. Update MySQL with if condition
  5. How does MySQL handle concurrent inserts?
  6. Put MySQL database under version control?
  7. Retrieving the coordinates of the MySQL point type
  8. “Unknown column in ‘field list'”, but column does exist
  9. MySQL connection over SSH tunnel
  10. Laravel Eloquent Ignore Casing
  11. MySQL licensing and GPL [closed]
  12. How do I combine the results of two queries with ordering?
  13. How to get back Lost phpMyAdmin Password, XAMPP
  14. How to do unique constraint works with NULL value in MySQL
  15. QMYSQL driver available but not loaded
  16. Database Historization
  17. How we can find domain name using MySQL and regular expression
  18. Transpose mysql query rows into columns
  19. UTF8 problem with MySQL 5
  20. ERROR 1115 (42000): Unknown character set: ‘utf8mb4’
  21. make an ID in a mysql table auto_increment (after the fact)
  22. Bind address and MySQL server [closed]
  23. mySQL returns all rows when field=0
  24. When is using MySQL BLOB recommended?
  25. MYSQL Select One Random record from each Category
  26. How do I make a MySQL database run completely in memory?
  27. Mysql Average on time column?
  28. How to recover just deleted rows in mysql?
  29. In MySQL SERVER 8.0 the PASSWORD function not working
  30. Using OR in LIKE Query in MySQL to compare multiple fields

Leave a Comment