Posted by Hugo Kornelis on 11/06/07 22:28

On Tue, 06 Nov 2007 18:17:05 -0000, iano wrote:

>I thought I saw this done once before. So today I hunted around in
>Books OnLine and did a Google search. So far I have found nothing
>close. So if you know how to do it, please tell me or if cannot be
>done, I'd appreciate know that too.

Hi IanO,

Open Object Explorer with F8 (of you don't have it open yet), expand
"Databases", then the name of your DB, then "Tables", then the name of
your table. Now, drag the "Columns" map to the editor window and a list
of all columns will automagically appear.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: Copy table column names from SSMS Object Browser to use in a query
• Prev in forum: Re: migration iwithin sql
• Thread view: Re: Copy table column names from SSMS Object Browser to use in a query

[Reply to this message]