List of SQL table that have data in it

F

FRED

I want to create a query to return all table name in my SQL database that has
more than 0 records how can I do that ?

Thanks

FRED
 
S

Sylvain Lafontaine

Sounds like homework for school.

Ask your question in m.p.sqlserver.programming to know how to use the
sysobjects table or take a look by yourselve. The use of INFORMATION_SCHEMA
is another option.

The online help for SQL-Server (BOL) has full details about sysobjects and
INFORMATION_SCHEMA .
 
F

FRED

I would pay a fortune to get back to my school year ! ! !. your name sounds
french canadian ! Just curious because I am.

Frédéric Fortin
 
S

Sylvain Lafontaine

Oui, c'est exact.

Il y a également des groupes de discussion francophones:
microsoft.public.fr.*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Help creating a search form in Access XP 0
Incone & Expenses Statement 0
Can I save a sql statement generated by a search form? 1
Adding data to MS Access from csv file 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Crating User Form to Add Names 1
How to have two tables on same line? 1

Top