Regarding SQL QUERY BUILDER

Question

1.00/5 (3 votes)

See more:

hi,

can i create sql query in query builder by selecting sql views instead of selecting sql tables??
please someone help me...!

Posted 28-Oct-15 4:11am

Member 12094561

Updated 28-Oct-15 4:19am

Andy Lanng

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Andy Lanng · Answer 1 · 2015-10-28T04:20:00

Solution 1

Yes. It is common practice.

When adding tables, the second tab should be "Views"

Posted 28-Oct-15 4:20am

Andy Lanng

Comments

Member 12094561 29-Oct-15 1:44am

hi,

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

my question was..in 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....

Regards
Pavan

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

http://www.sourcecodester.com/tutorials/visual-basic-net/5889/simple-query-builder-using-visual-basicnet.html

once go though this link...u will understand,what i want...in that link he is selecting tables to generate query,..bt 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:
"SHOW TABLES FROM [db]"

This will return all tables and views by default.

You can check the type by using the query:
"SHOW FULL TABLES FROM [db]"

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
with
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.