Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    May 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up *Resolved* SQL Server - Getting Field/Table List

    Hi there,

    Is there a way of printing out, or getting some kind of text file listing of all the tables, fields within them, and if possible the field type?

    Can you do it from SQL or do you need to run some ASP script, etc for it?

    Cheers,
    Sparky.
    Last edited by enginious; 05-04-2005 at 01:57 PM. Reason: Resolved

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Zwolle, The Netherlands
    Posts
    1,120
    Thanks
    2
    Thanked 31 Times in 31 Posts
    The information is there, you have to use a tool to extract it from the database. As far as i know, you can use any reporting tool to do that. So ASP would be an option.

    If the format it's in doesn't matter, you can also do a Generate SQL on the database (from Enterprise manager), select all tables and go for it.
    Now you have a sql script to regenerate the database, this holds all the info about the tables, columns and types
    I am the luckiest man in the world

  • #3
    New to the CF scene
    Join Date
    May 2005
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thanks

    Thanks a lot for your help, I hadnt thought about the Generate SQL option.

    Much appreciated,
    Sparky.


  •  

    Posting Permissions

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