Select * table names from database. 3

[rtshort]

I need to get all of the table names from a database to populate a list box in VB. Can anyone please give me a little sample SQL Statement to select all of them.

I use SQL Server 7.0

TIA Every day above ground is a GOOD DAY!!!

 

[AshleyRickards]

Select name from databasename.sysobjects where xtype = 'U'
That should work for you. Ashley L Rickards
SQL DBA

 

[lachie]

Alternatively you can use the

sp_helpdb

stored procedure.

 

[rtshort]

ASH001, works like a dream thanks.

Lachie, I don't see a sp_helpdb stored procedure, but I'll continue to look for it.

I'm just getting into SQL and VB so I may be kind of slow.

Thanks again to both of you. Every day above ground is a GOOD DAY!!!

 

[tlbroadbent]

sp_helpdb is in the master database. It a system stored procedure that can be executed within the context of any database. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[rtshort]

The SQL Statement that ASH001 recommends works well, but it returns a table called "dtproperties" and I don't want it to be in the listbox with the other table names. Is there a way to omit this table and just populate the list box with the remaining table names. Every day above ground is a GOOD DAY!!!

 

[AshleyRickards]

Add "and name not like 'dtproprerties' in the where statement. Ashley L Rickards
SQL DBA

 

[rtshort]

Worked like a dream ASH001. Thanks a million. I really appreaciate all of you taking the time to answer. Rob
Just my $.02.