Extracting Tables and columns with data types from a database

Discussion in 'ASP .Net' started by RSH, Jun 2, 2005.

  1. RSH

    RSH Guest

    Im trying to write a simple app that will show all of the user created
    tables along with their columns and column datatypes.

    Any suggestions on how to approach this???

    Thanks!
     
    RSH, Jun 2, 2005
    #1
    1. Advertisements

  2. For this you need to access the database metadata. In SQL server you can
    obtain metadata either with system stored procedures or with information
    schema views. Search your database documentation for "metadata".

    Eliyahu

    "RSH" <> wrote in message
    news:uZQ%...
    > Im trying to write a simple app that will show all of the user created
    > tables along with their columns and column datatypes.
    >
    > Any suggestions on how to approach this???
    >
    > Thanks!
    >
    >
     
    Eliyahu Goldin, Jun 2, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. nabil m
    Replies:
    1
    Views:
    6,015
    SevDer
    Sep 10, 2004
  2. Replies:
    5
    Views:
    846
  3. Toto
    Replies:
    5
    Views:
    858
  4. Chris Brat
    Replies:
    5
    Views:
    919
    =?iso-8859-1?q?Luis_M._Gonz=E1lez?=
    Aug 22, 2006
  5. Steve Kershaw
    Replies:
    2
    Views:
    467
    Steve Kershaw
    Nov 9, 2006
  6. ramu
    Replies:
    2
    Views:
    555
    rlblaster
    Feb 20, 2006
  7. nmsreddi
    Replies:
    1
    Views:
    238
    Prakash V
    Jun 9, 2006
  8. Gary Roach
    Replies:
    0
    Views:
    243
    Gary Roach
    Sep 1, 2013
Loading...