Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Angry Unanswered: generate attributelist from tables

    hi there!
    I've been working on a project in ASP.NET and SQLserver 2000.
    Since this is actually something for school, I must give a report on my work done here.
    What I want to do is make an attributelist of all the tables that are in a database, or one at the time would already be a great help!
    So for each table I would need in text format all its column names, types en 'allow null' property, but I just can't find out how or with what to do this.

    thanks for your help!
    Tomba

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    select * from INFORMATION_SCHEMA.COLUMNS
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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