Retrieve all table names of a database

Question

1.00/5 (1 vote)

See more:

SQL

Hello everyone

How can i get all the table names of database and display these table names using combo box. Or store the table names in an array . I am using sqlexpress and c#

Posted 15-Oct-11 18:15pm

manu g m

Add a Solution

3 solutions

Solution 2

Use the following query when you have connected to you database server

SQL

select * from information_schema.tables

Posted 15-Oct-11 18:33pm

Mehdi Gholam

Comments

Sergey Alexandrovich Kryukov 16-Oct-11 1:49am

Correct, my 5, but OP asked about filling an array with this data. I added answer to this question to my solution, this time seriously. Please see.
--SA

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)

Sergey Alexandrovich Kryukov · Accepted Answer · 2011-10-15T18:28:00

Solution 1

SELECT * FROM Google WHERE (question like 'all tables') AND (database ='SQL Server Express')

[EDIT]

Answering a follow-up question:

Look at your own solution using SqlDataReader. Instead of adding items to a combo box or list box, add the first in some list such as System.Generic.Collection.List<string>. When the list is filled with data, you can turn it into array using its method ToArray.

—SA

Posted 15-Oct-11 18:28pm

Sergey Alexandrovich Kryukov

Updated 15-Oct-11 19:51pm

v4

Comments

Mehdi Gholam 16-Oct-11 0:30am

Hehe!

manu g m 16-Oct-11 0:32am

How can i store this in an array please help.

Sergey Alexandrovich Kryukov 16-Oct-11 1:41am

Most direct way: use DataReader, see http://msdn.microsoft.com/en-us/library/haa3afyz%28v=VS.100%29.aspx. All such methods depends on provider -- types are different, but very similar, nearly identical in use.
--SA

Sergey Alexandrovich Kryukov 16-Oct-11 1:54am

OK, I updated my solution. Please see after [EDIT].
--SA

Mehdi Gholam 16-Oct-11 1:41am

I don't know whether to laugh or cry, your solution was accepted!!!

Sergey Alexandrovich Kryukov 16-Oct-11 1:51am

Better keep calm :-). OP was wise enough, that's why. He knew I would answer about array later on -- please see. Other than that, his own solution almost solved the problem. How do you think why? I think OP just used my query and got some suggestions form Google. :-)
--SA

Mehdi Gholam 16-Oct-11 1:57am

My 5 for sheer comedic value!

Sergey Alexandrovich Kryukov 16-Oct-11 1:58am

Thank you, but you also cannot deny it worked. :-)
Besides, my "comedic" solution will probably be used for wide range of problems in future.
Ever heard of Stanislavski's system? That's it: http://en.wikipedia.org/wiki/Stanislavski%27s_system.
Read about super-objective to understand what do I mean.
--SA

manu g m · Accepted Answer · 2011-10-15T18:36:00

C#

SqlConnection con1 = new SqlConnection(connection);
            con1.Open();
            SqlCommand cmd1 = new SqlCommand("select name from dbo.sysobjects where xtype='U' ", con1);
            cmd1.ExecuteNonQuery();
            SqlDataReader dr = cmd1.ExecuteReader();
            while (dr.Read())
                comboBox1.Items.Add(dr[0].ToString());