Click here to Skip to main content
15,069,020 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
See more:

can i create sql query in query builder by selecting sql views instead of selecting sql tables??
please someone help me...!
Updated 28-Oct-15 4:19am

1 solution

Yes. It is common practice.

When adding tables, the second tab should be "Views"
Member 12094561 29-Oct-15 1:44am

sorry i guess,my question was not clear to u,..

my question query builder we select some tables from database and we generate the query right...
In the same manner i want to generate a query by selecting sql views instead of selecting tables....

Andy Lanng 29-Oct-15 4:59am
Query builder in SQL Management Studio? There is a table next to tables when selecting tables for views.
Or are you using a different 'Query Builder'? There are many :S
Member 12094561 29-Oct-15 8:39am
i want to share an screenshot,is there any way here to share??so that ul get an clear idea of my req.
Member 12094561 29-Oct-15 8:42am

once go though this link...u will understand,what i that link he is selecting tables to generate query, i want to select views instead of tables..please go through that link
Andy Lanng 29-Oct-15 9:11am
Ah - I see. That's dead simple.

You have a query that shows tables:

This will return all tables and views by default.

You can check the type by using the query:

That will return two columns. The table and the table type ("BASE TABLE"|"VIEW")

but in order to use them, you have to perform a "SELECT" instead of a "SHOW". That's a little different:
"SELECT CONCAT(Table_name," (", Table_Type, ")") AS 'tables_in_[db]' FROM information_schema.Tables WHERE Table_schema = '[db]'"
You can use that query in place of "SHOW TABLES FROM " & cbdb.Text and it will show the values as: "tablename (BASE TABLE)" and "viewname (VIEW)".

To be clear: Replace the line:
Dim sql As String = "SHOW TABLES FROM " & cbdb.Text
Dim sql As String = String.Format("SELECT CONCAT(Table_name," (", Table_Type, ")") AS 'tables_in_{0}' FROM information_schema.Tables WHERE Table_schema = '{0}' ", cbdb.Text)
Member 12094561 29-Oct-15 9:29am
thnx Andy Lanng...thnx loads!
il check that and will be back again..
Thnx again.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900