Results 1 to 4 of 4

Thread: [RESOLVED] [2005] How to listout databases and table names?

  1. Jan 23rd, 2007, 02:04 AM #1
    senthilkumartd
    senthilkumartd is offline

    Thread Starter
    Addicted Member senthilkumartd's Avatar
    Join Date
    Feb 2005
    Posts
    206

    Resolved [RESOLVED] [2005] How to listout databases and table names?

    How to list out databases and table names of a particular user id through coding?
    God has been pleased to place as a king or cobbler do the work sincerely
    Reply With Quote Reply With Quote
  2. Jan 23rd, 2007, 05:45 AM #2
    Asgorath
    Asgorath is offline
    Frenzied Member Asgorath's Avatar
    Join Date
    Sep 2004
    Location
    Saturn
    Posts
    2,036

    Re: [2005] How to listout databases and table names?

    Once you have established a connection to the sql server , use the following commands
    sp_databases
    sp_tables
    "The dark side clouds everything. Impossible to see the future is."
    Reply With Quote Reply With Quote
  3. Jan 23rd, 2007, 06:44 AM #3
    senthilkumartd
    senthilkumartd is offline

    Thread Starter
    Addicted Member senthilkumartd's Avatar
    Join Date
    Feb 2005
    Posts
    206

    Re: [2005] How to listout databases and table names?

    thanks
    God has been pleased to place as a king or cobbler do the work sincerely
    Reply With Quote Reply With Quote
  4. Jan 23rd, 2007, 07:01 AM #4
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,222

    Re: [RESOLVED] [2005] How to listout databases and table names?

    You can also use the GetSchema method of your connection object.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width