Sunday, February 19, 2012

How to check whether Server is Exists with some Table in Particular Database.

hi,

I want to know through applicaiton how to check whether the Server named"Myserver" is Exists with Database named "MyDatabase" with Tables named ('Table1','Table2','Table3').

For any Database like (MS Access, Oracle, MS SQL-Server,MySQL)..

Please help me.....

thank's in advance.......

Paresh Patel.

Paresh.onmail@.hotmail.com

The syntax would be a bit different for different databases, but basically I believe that the procedure would be the same for all..

You'd have to:

1) connect and login to the server 'Myserver'
2) ask it if 'MyDatabase' exist (eg try use MyDatabas)
3) check for existence of 'Table1', 'Table2' etc (eg try access tables, check for objectnames etc)

You'd also need to know a valid login with appropriate permissions to do this.

/Kenneth

No comments:

Post a Comment