Anyone know if there's a system resource like in Oracle where you can SELECT tablename FROM user_tables? I know there must be. I just want to make a simple report listing all 100+ tables in a DB and their recordcounts.
Printable View
Anyone know if there's a system resource like in Oracle where you can SELECT tablename FROM user_tables? I know there must be. I just want to make a simple report listing all 100+ tables in a DB and their recordcounts.
Yes, run the query:
select name, * from sysobjects where type = 'u' order by name
------------
Greg Luce at 12/7/2001 9:15:44 AM
Anyone know if there's a system resource like in Oracle where you can SELECT tablename FROM user_tables? I know there must be. I just want to make a simple report listing all 100+ tables in a DB and their recordcounts.