List of all columns+attributes for a DB

• jblovesthegym

  Ten Centuries

  Points: 1048

  More actions

  June 29, 2012 at 2:59 am

  #98242

  Hi all,

  Any script that yields the above for SS2K?

  Cheers,

  JB

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  July 1, 2012 at 10:39 pm

  #1507600

  All you need is a simple select on table syscolumns such as

  SELECT object_name(ID), * FROM syscolumns