title: How do I change the default SELECT TOP 1000 query to use * instead of each field?
body: <p>In SSMS 2008 R2, we have the default Select top 1000 and Edit top 200 queries from the right click menu.  I've seen where you can change the # of rows it returns in the options.</p>
  
  <p>What I'm after is, can I tell it to do a SELECT * instead of expanding and including every field?  </p>
  
  <p>It's not a performance issue or anything, just an annoyance when querying tables with more than about 5 fields, I'd like do a select *.</p>
  
  <p>For example, if I have a table with the following fields:</p>
  
  <ul>
  <li>FirstName</li>
  <li>LastName </li>
  <li>Birthday</li>
  <li>City </li>
  <li>State </li>
  <li>Zip</li>
  </ul>
  
  <p>When I right click on this Persons table and choose the "SELECT TOP 1000 ROWS" Menu, I'd like the query that is run to be </p>
  
  <pre><code>SELECT TOP 1000 *  FROM People
  </code></pre>
  
  <p>and NOT</p>
  
  <pre><code>SELECT TOP 1000 FirstName, LastName, Birthday, City, State, Zip FROM People
  </code></pre>
  
  <p><strong>EDIT</strong> I suspect there isn't really an answer to this, but thought I'd see if anyone figured it out.</p>