Truncate table not working with SQL server sqlalchemy engine and pandas : <p>I can successfully query and insert data using sqlalchemy and pandas:</p>

<pre><code>from sqlalchemy import create_engine
import pandas as pd
engine = create_engine('mssql://myserver/mydb?driver=SQL+Server+Native+Client+11.0?trusted_connection=yes')
</code></pre>

<p>Read tempy table:</p>

<pre><code>sql_command = """
select top 100 * from tempy
"""

df = pd.read_sql(sql_command, engine)
print df

   tempID  tempValue
0       1          2
</code></pre>

<p>Append new data:</p>

<pre><code>df_append = pd.DataFrame( [[4,6]] , columns=['tempID','tempValue']) 
df_append.to_sql(name='tempy', con=engine, if_exists = 'append', index=False)

df = pd.read_sql(sql_command, engine)
print df

   tempID  tempValue
0       1          2
1       4          6
</code></pre>

<p><em>Try</em> to truncate data:</p>

<pre><code>connection = engine.connect()
connection.execute( '''TRUNCATE TABLE tempy''' )
connection.close()
</code></pre>

<p>Read table again, but truncate failed:</p>

<pre><code>df = pd.read_sql(sql_command, engine)
print df

   tempID  tempValue
0       1          2
1       4          6
</code></pre>
