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. Advertising

  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. Advertising

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. Replies:
    5
    Views:
    594
  2. Chris Brat
    Replies:
    5
    Views:
    695
    =?iso-8859-1?q?Luis_M._Gonz=E1lez?=
    Aug 22, 2006
  3. ramu
    Replies:
    2
    Views:
    325
    rlblaster
    Feb 20, 2006
  4. nmsreddi
    Replies:
    1
    Views:
    151
    Prakash V
    Jun 9, 2006
  5. Gary Roach
    Replies:
    0
    Views:
    111
    Gary Roach
    Sep 1, 2013
Loading...

Share This Page