Getting a list of table names using VBSQL?.? 
Author Message
 Getting a list of table names using VBSQL?.?

How can you get a list of all the table names from a reticular database
using VBSQL?

I know I have asked how to do the same thing before but with other methods
like RDO and ADO, this time I'm looking on how to do it with VBSQL.  Does
anyone have any ideas?

--
Chris Barger
L3 Communications - Satellite Transmission System
Digital Systems Division
Voice (516) 272-5796



Mon, 25 Sep 2000 03:00:00 GMT  
 Getting a list of table names using VBSQL?.?

Here you go:

Select * from sysobjects Where type = 'U'

Quote:

>How can you get a list of all the table names from a reticular database
>using VBSQL?

>I know I have asked how to do the same thing before but with other methods
>like RDO and ADO, this time I'm looking on how to do it with VBSQL.  Does
>anyone have any ideas?

>--
>Chris Barger
>L3 Communications - Satellite Transmission System
>Digital Systems Division
>Voice (516) 272-5796




Sat, 30 Sep 2000 03:00:00 GMT  
 Getting a list of table names using VBSQL?.?

How do I do this using RDO?



Quote:
> Here you go:

> Select * from sysobjects Where type = 'U'


> >How can you get a list of all the table names from a reticular database
> >using VBSQL?

> >I know I have asked how to do the same thing before but with other
methods
> >like RDO and ADO, this time I'm looking on how to do it with VBSQL.
Does
> >anyone have any ideas?

> >--
> >Chris Barger
> >L3 Communications - Satellite Transmission System
> >Digital Systems Division
> >Voice (516) 272-5796




Sat, 07 Oct 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. getting a list of table names

2. Getting the list of Excel Sheet Names using VBA

3. Getting NetBIOS Remote Machine Name Table using VB?

4. Getting NetBIOS Remote Machine Name Table using VB?

5. Getting NetBIOS Remote Machine Name Table using VB?

6. Getting a List of tables using VBA??

7. Getting table names without actually knowing their names...

8. Getting table names without actually knowing their names...

9. Getting table names without actually knowing their names...

10. Getting table names without actually knowing their names...

11. using table field names after table connect

12. Cannot open a table because table name uses accent letter

 

 
Powered by phpBB® Forum Software