473,324 Members | 2,179 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

How to select all tables in a database?

hi,

if anyone can help me please,

i nead to select all the tables in my database in one instruction. all the tables have the same structure.
the problem is that i dont know the number of tables neighter their names.

i nead a solution like SELECT * from database_name.*

thanks
Oct 20 '10 #1
2 1259
code green
1,726 Expert 1GB
If you don't know your database structure how can you query it?
To SELECT tables makes no sense.
If you want to SELECT data from multiple tables you need JOIN
Oct 21 '10 #2
Ravi L
12
I dont get exactly what you are trying to do. Below are some suggestions:
List all tables in the database-
Select * from sys.objects where type='u'

Generate Select query for all tables in database-
Select 'Select * from '+name from sys.objects where type='u'

Further to this, clarify exactly what you intend to do.
Oct 21 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Mikko Pulkkinen | last post by:
Hi, I'm trying to use Crystal Reports to generate reports from an Access database. I'm using VS2003 and C#. I need to select the database the report uses as data source at runtime. The database...
3
by: Random Person | last post by:
Does anyone know how to use VBA to relink tables between two MS Access databases? We have two databases, one with VBA code and the other with data tables. The tables are referenced by linked...
5
by: Christoph Sticksel | last post by:
Hi, I'm having problems with attaching two tables stored in an SQL Server 2000 to an Access 97 database. It worked well for all other tables except those two. This is what I did: Choose the...
3
by: josh.kuo | last post by:
Sorry about the subject, I can't think of a better one. I recently wrote some PHP classes that I think might be of interest to this group. Since I have been reaping the benefits of reading news...
3
by: mike7510uk | last post by:
hi, i have a gridview with a templatefield that contains a checkbox. this all works fine and update database fine. But the problem i have is that if the user checks a box, closes the application,...
5
by: Edwin Smith | last post by:
Hello: I'm using VS2005 with an ODBC database. I am trying to add a Dialog to an existing Database application to allow the user to select the database. We have 2 different databases with the...
1
by: fran7 | last post by:
Hi, I have this code to randomly select an image from a sequence of fields in my database. Does anyone know if rather than random, one could simply move from one field to the next sequentialy. That...
1
by: Tony Johansson | last post by:
Hello! I use VS 2005. A Datasource can be a Database, Web Service or an Object. So I select Data->Add New Data Source in the menu. In the dialog data Source Configuration Wizard I choose...
8
by: sloney | last post by:
I am trying to build relationships between mulitple tables and was wondering if there is a way to determine all tables in a database that contain the same attribute. Thanks in advance for your...
1
by: abhishek1234321 | last post by:
I there any way to select tables using wildcards? like for example i have 100 tables in my database with names "1rn08cs001" "1rn08cs002"... etc now i want a wild card method to select oly the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.