title: How can I get column name and type from an existing table in SQLAlchemy?
body: <p>Suppose I have the table <code>users</code> and I want to know what the column names are and what the types are for each column.</p>
  
  <p>I connect like this; </p>
  
  <pre><code>connectstring = ('mssql+pyodbc:///?odbc_connect=DRIVER%3D%7BSQL'
                       '+Server%7D%3B+server%3D.....')
  
  engine = sqlalchemy.create_engine(connectstring).connect()
  md = sqlalchemy.MetaData()
  table = sqlalchemy.Table('users', md, autoload=True, autoload_with=engine)
  columns = table.c
  </code></pre>
  
  <p>If I call </p>
  
  <pre><code>for c in columns:
              print type(columns)
  </code></pre>
  
  <p>I get the output</p>
  
  <pre><code>&lt;class 'sqlalchemy.sql.base.ImmutableColumnCollection'&gt;
  </code></pre>
  
  <p>printed once for each column in the table. 
  Furthermore, </p>
  
  <pre><code>print columns 
  </code></pre>
  
  <p>prints </p>
  
  <pre><code>['users.column_name_1', 'users.column_name_2', 'users.column_name_3'....]
  </code></pre>
  
  <p>Is it possible to get the column names without the table name being included? </p>