Page 1 of 1

Plz help with checking if database has any information..

Posted: Fri Jan 31, 2003 1:03 pm
by runelore
Hi i wanna be able to check if there are any entres at all in the entire database. What i mean is that I have a database with quite a few tables. I need a way to just check if any information is stored in any of the fields in any of the tables within that database. I know it doesn't work but something like :

Code: Select all

Select * from 'database'
Would be perfect but i know I cant do that, can anyone help. please... Thank you....

Posted: Fri Jan 31, 2003 4:49 pm
by evilcoder
could probably try: SELECT * FROM *

but i've never done that and personally dont think SQL lets you link tables so easily. But give it a shot!

Posted: Fri Jan 31, 2003 8:20 pm
by fractalvibes
Perhaps try a few queries against some of the tables and see if you get any results....

If your database has a catalogue you might could query directly against it,
i.e. the metadata regarding the database and get an answer there.

Phil J.