Copy table column names from SSMS Object Browser to use in a query

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • iano
    #1

    Copy table column names from SSMS Object Browser to use in a query

    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.

    Thanks in advance,
    IanO

    Tags: None
    • Hugo Kornelis
      #2
      Re: Copy table column names from SSMS Object Browser to use in a query

      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

        Comment

        • Erland Sommarskog
          #3
          Re: Copy table column names from SSMS Object Browser to use in a query

          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@sommarsk og.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

            Comment

            Previous template Next
            Working...