vb: check if table already exists?? 
Author Message
 vb: check if table already exists??
Hello,

How could I check, if a table already exists???

THank you very much

Ciao
Martin



Thu, 14 Apr 2005 20:33:31 GMT
 vb: check if table already exists??



Quote:
> Hello,

> How could I check, if a table already exists???

> THank you very much

> Ciao
> Martin

I found the solution for my problem:

with rsT
        .ActiveConnection = cn
        .CursorLocation = adUseClient
        .Source = "SELECT * FROM sysobjects where xtype='U' and info=5"
        .Open
end with



Fri, 15 Apr 2005 01:38:57 GMT
 vb: check if table already exists??
Tom's solution is about 1000 times more efficient than retrieving ALL your
table names into a client recordset (especially using SELECT *, and relying
on sysobjects), and Joe makes excellent points as well.


Quote:


> > Hello,

> > How could I check, if a table already exists???

> > THank you very much

> > Ciao
> > Martin

> I found the solution for my problem:

> with rsT
>         .ActiveConnection = cn
>         .CursorLocation = adUseClient
>         .Source = "SELECT * FROM sysobjects where xtype='U' and info=5"
>         .Open
> end with



Fri, 15 Apr 2005 01:43:05 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. How to check if an tempory table already exists

2. check if table already exists??

3. How to check if a table already exists

4. Checking if a #temp1 table exists already

5. How to check if Temp SP already exist

6. Checking if a Global Variables already exists

7. Check if cursor already exists.

8. Check if temp. SP already exists

9. Check if a file already exists

10. how to check if a cursor already exists...

11. table already exists error

12. Temporary Table already exists


 
Powered by phpBB® Forum Software