Returning a list of views from MySql Database C#

Kamlesh Singh

I'm building a simple WPF app for my colleagues to use in order to query one of our databases.

In the UI I'm trying to allow them to select a pertinent view from which to query. Using the answer in this question fro stackoverflow: Get the column names of a table and store them in a string or var c# asp.net I'm going to also list the columns that they will have access to within the view.

To do this, I've been looking for a way to construct a dynamically generated query based on the groundwork of the above link. I'll be changing their query to something like this:

string NameOfView = "View1"; string dynamicQuery = "SELECT * FROM " + NameOfView; MySqlCommand(dynamicQuery, connection);

In essence, I want to know what possible permutations View1 could be for the particular MySql connection.

Thanks & Regards

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R7y ago
Hi,
Can you check with the below link:
https://stackoverflow.com/questions/2834016/how-to-get-a-list-of-mysql-views
0
Mario Scheeren7y ago
You can also list all the views using the SQL below.

SELECT TABLE_NAME FROM information_schema.`TABLES` WHERE TABLE_TYPE LIKE 'VIEW' AND TABLE_SCHEMA LIKE 'database_name';

Similarly, you can run the following SQL to get the list of all tables.

SELECT TABLE_NAME FROM information_schema.`TABLES` WHERE TABLE_TYPE LIKE 'BASE TABLE' AND TABLE_SCHEMA LIKE 'database_name';
0