Dynamically selecting all tables

[Newsgroup_User]

Anyone know of a way to select all "Tables" in a database? I'm trying to
populate a list menu with the table names of a SQL Server database.

TIA

Bill

[Newsgroup_User]

here's one way:

SET NOCOUNT ON
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
SET NOCOUNT OFF

HTH
--
Tim Carley
www.recfusion.com
info@NOSPAMINGrecfusion.com

[Newsgroup_User]

That did it. Thanks Mountain Lover. I've never had a need to do that before.
Glad you pointed it out.

Bill


"Mountain Lover" <info@NOSPAMrecfusion.com> wrote in message
news:e9h8l0$fkr$1@forums.macromedia.com...
> here's one way:
>
> SET NOCOUNT ON
> SELECT TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> WHERE TABLE_TYPE = 'BASE TABLE'
> SET NOCOUNT OFF
>
> HTH
> --
> Tim Carley
> www.recfusion.com
> info@NOSPAMINGrecfusion.com