Is there a way to get if a column is automatically incremented and signed / unsigned in pyodbc?

I am trying to get metadata from columns in a MySQL table using pyodbc.

I have looked at cursor.columns which contains more or less what I need, only it doesn't ensure that the column is auto-incremented or not. Also, it does not provide fields to display if the value is signed or unsigned.

I know this can be retrieved from the INFORMATION_SCHEMA.COLUMNS table, but I would like to avoid creating queries for that table.

So, is there a good way to achieve this using pyobbc's built-in functions?



source to share

All Articles