Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. Getting tables from a database

Getting tables from a database

Scheduled Pinned Locked Moved Database
csharpdatabasequestion
3 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    MarkB777
    wrote on last edited by
    #1

    Maybe i've overlooked it, but can someone tell me how I could get a list of all the tables in a database once i've connected? (C#). Thankyou. Mark.

    P R 2 Replies Last reply
    0
    • M MarkB777

      Maybe i've overlooked it, but can someone tell me how I could get a list of all the tables in a database once i've connected? (C#). Thankyou. Mark.

      P Offline
      P Offline
      pmarfleet
      wrote on last edited by
      #2

      It depends on what type of database you're using. People at CodeProject aren't psychic, so you'll have to provide that information if you want help.

      Paul Marfleet "No, his mind is not for rent To any God or government" Tom Sawyer - Rush

      1 Reply Last reply
      0
      • M MarkB777

        Maybe i've overlooked it, but can someone tell me how I could get a list of all the tables in a database once i've connected? (C#). Thankyou. Mark.

        R Offline
        R Offline
        Rajkamal_dfine
        wrote on last edited by
        #3

        If you using SQL Server Try this select object_name(id) from sysObjects where type = 'u'

        N.Rajakumar B.E., Application Developer,

        1 Reply Last reply
        0
        Reply
        • Reply as topic
        Log in to reply
        • Oldest to Newest
        • Newest to Oldest
        • Most Votes


        • Login

        • Don't have an account? Register

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • World
        • Users
        • Groups