title: SQL Server Mgmt Studio shows "invalid column name" when listing columns?
body: <p>I'm used to scripting in Python or Matlab, and my first couple hours with SQL have been infuriating.  I would like to make a list of columns appear on the screen in any way, shape, or form; but when I use commands like</p>
  
  <pre><code>select * 
  from "2Second Log.dbo.TagTable.Columns"
  </code></pre>
  
  <p>I keep getting the error:</p>
  
  <blockquote>
    <p>Invalid column name '[the first column in my table]'.</p>
  </blockquote>
  
  <p>even though I never explicitly asked for [the first column in my table], it found it for me.  How can you correctly identify the first column name, and then still claim it's invalid!?  Babies will be strangled.</p>
  
  <p><a href="https://i.stack.imgur.com/FJBXo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FJBXo.png" alt="My data structure, query, and the error message."></a></p>
  
  <p>This db was generated by Allen Bradley's FactoryTalk software. What I would really like to do is produce an actual list of "TagName" strings...but I get the same error when I try that.  If there were a way to actually double click the table and open it up and look at it (like in Matlab), that would be ideal.</p>