•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 373,375 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,801 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 1856 | Replies: 4 | Solved
 |
•
•
Join Date: May 2007
Location: India
Posts: 493
Reputation: 
Rep Power: 2
Solved Threads: 45
Posting Pro in Training
How to retrieve table names 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
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
Shouvik_The_Expert_Coder
Have a problem? Don't worry just give me a call and I'll fix it for you.
Have a problem? Don't worry just give me a call and I'll fix it for you.
•
•
Join Date: May 2007
Location: India
Posts: 493
Reputation:
Rep Power: 2
Solved Threads: 45
Posting Pro in Training
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
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
Shouvik_The_Expert_Coder
Have a problem? Don't worry just give me a call and I'll fix it for you.
Have a problem? Don't worry just give me a call and I'll fix it for you.
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,026
Reputation:
Rep Power: 8
Solved Threads: 227
•
•
•
•
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.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: May 2007
Location: India
Posts: 493
Reputation:
Rep Power: 2
Solved Threads: 45
Posting Pro in Training
Ok....here is the code that I used....
regards
Shouvik
''opening my database use BILLING_SYSTEM ''fetching all tables select distinct name from sysobjects where xtype='U'
regards
Shouvik
Last edited by choudhuryshouvi : Apr 5th, 2008 at 10:56 am.
Shouvik_The_Expert_Coder
Have a problem? Don't worry just give me a call and I'll fix it for you.
Have a problem? Don't worry just give me a call and I'll fix it for you.
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,026
Reputation:
Rep Power: 8
Solved Threads: 227
Thanks
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
ajax asp database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development gpt guid partition table hacker management studio 2005 microsoft msdn news office partition security software sql sql cache dependency with polling-based invalidation survey vista
- Send data on a serial port (C++)
- MS Access data retrieval problem (Visual Basic 4 / 5 / 6)
- retrieve data (MS SQL)
- ASP add, update and delete (ASP)
- VB6 and MS Access 2002 (Visual Basic 4 / 5 / 6)
- Make data from a pull down list mandatory (Visual Basic 4 / 5 / 6)
- need help to debugg this code please! (C++)
- SQL Injection Attack (Database Design)
Other Threads in the MS SQL Forum
- Previous Thread: How to create SECURITY LOGIN from front-end coding
- Next Thread: proble with import from excel
