Switch column introspection to use sp_columns instead of cursor.columns

michiya / django-pyodbc-azure

Django backend for Microsoft SQL Server and Azure SQL Database using pyodbc

https://pypi.python.org/pypi/django-pyodbc-azure

BSD 3-Clause "New" or "Revised" License

321 stars 140 forks source link

Switch column introspection to use sp_columns instead of cursor.columns #199

Open wgordon17 opened 5 years ago

wgordon17 commented 5 years ago

I found cursor.columns to be less than reliable in returning any results. The sp_columns returns the exact same data, and in local testing, was reliable 100% of the time for ~520 tables.