column list...

is there way to get a paste-able column list of a table? a report on

columns? have table with 100+ cols, and would like to cut/paste in to

Word doc..

thanks!

SELECT Column_name From Information_Schema.Columns
Where table_name = 'YourTableName'

(Results to Grid, Mark the Grid Copy & Paste)

or sp_help 'Tablename', produces the same (column)resultsset.

HTH, Jens Suessmeyer.