Looking for a simple script

• Charlie-120533

  SSCrazy

  Points: 2187

  More actions

  November 5, 2004 at 9:58 am

  #85975

  Hey all,

  I'm looking for a simple script that will take the schema information (looking like the Design Table) from all the tables in a database and place them into an Excel spreadsheet.  Does this sound feasible?

   

  All help is appreciated.

   

  Thanks in advance.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 734661

  More actions

  November 5, 2004 at 10:50 am

  #529127

  select * from information_schema.columns. Sort, rearrange as you like, then save the data into a file. (CSV) and open in Excel.

• Charlie-120533

  SSCrazy

  Points: 2187

  More actions

  November 5, 2004 at 10:55 am

  #529128

  Steve - Thanks for the quick reply.  That gives me exactly what I need.

   

  Great site, by the way.