List of SQL table that have data in it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 .
 
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
 
Oui, c'est exact.

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