0

I've developed a software using VB6 and MSSQL 7.0. Now I need to create a backup-restore program on behalf of my software. For this I need to fetch down all the table names located inside the database used in the software.

My database name is -->BILLING_SYSTEM
and I've also created a Security LogIn -- BS(BS) for this.
All jobs have been done using Sql Server Enterprise Manager.
My software uses an USER-DSN connection to communicate with the sql server.

Now my question is how can I issue an sql command which can fetch down all the table names
from the BILLING_SYSTEM database. I mean what is the sql query for that like we issue this in case of Oracle :-

SELECT * FROM SYSDBA_USERS WHERE OWNER='<DATABASE NAME>'

Can anybody help me????

regards
Shouvik

3
Contributors
5
Replies
6
Views
9 Years
Discussion Span
Last Post by dhanya_piit
0

thanks to all of you who made visit to this thread.
its pleasure to tell you guys that i've solved this problem. now i'm getting the table names from my sql database.

so, this thread is now closed.

thanks to all of you.....once again...
bye

0

its pleasure to tell you guys that i've solved this problem. now i'm getting the table names from my sql database.

It would have been much more better if you had mentioned how you solved your problem. :)

0

Ok....here is the code that I used....

[B]''opening my database[/B]
use BILLING_SYSTEM
[B]''fetching all tables[/B]
select distinct name from sysobjects where xtype='U'

regards
Shouvik

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.