Posted by Erland Sommarskog on 11/06/07 22:29

iano (IanONet@gmail.com) writes:
> 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.

Find the table in Object Explorer and expand the note. Select Columns
and drag it to the place where you want it.

My own take on this is that I simply run a SELECT * with TOP 1 or
WHERE 1 = 0 in text mode. I copy and paste into window in Textpad
where I have a macro that replaces the multiple spaces with comma +
space. Sounds kludgy? Well, navigating in an explorer tree takes time too.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: CASE count wierd join needed maybe? just one more field needed!
• Prev in forum: Re: Copy table column names from SSMS Object Browser to use in a query
• Thread view: Re: Copy table column names from SSMS Object Browser to use in a query

[Reply to this message]