Getting mssql table column name and datatype using pyodbc in python

Question

I am trying to get the mssql table column name and datatype using pyodbc

Here is my code:

def GetSQLTableFields(connDetails):
    cursor = conn.ConnectSQL(connDetails)
    cursor.execute("SELECT colum1, column2, column3 FROM TEST_TABLE")
    for col in cursor.description:
        print('name =', col[0], ', datatype =',col[1])
    cursor.close()

by using this code i'm not able to get the sql datatype of columns inseted i'm getting this

name = column1, datatype = <class 'str'>
name = column2, datatype = <class 'int'>

output i want

name = column1, datatype = nvarchar
name = column2, datatype = int

Does this answer your question? Get MSSQL table column names using pyodbc in python — user9517769
– user9517769, Commented May 18, 2020 at 11:38
No in the given example there is no datatype retrieval, and in my scenario the input is a sql query with mentioned column names not just a tableName — Vinayak
– Vinayak, Commented May 18, 2020 at 11:59

Gord Thompson · Accepted Answer · 2020-05-18 12:33:37Z

2

This is a long-standing feature request that has not been implemented in pyodbc itself.

https://github.com/mkleehammer/pyodbc/issues/167

You may want to try using the fork mentioned in that issue (if it is being maintained).

answered May 18, 2020 at 12:33

Gord Thompson

125k38 gold badges251 silver badges458 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting mssql table column name and datatype using pyodbc in python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related