For MySql, Check in the EXTRA column:

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'my_table'
    AND COLUMN_NAME = 'my_column'
    AND DATA_TYPE = 'int'
    AND COLUMN_DEFAULT IS NULL
    AND IS_NULLABLE = 'NO'
    AND EXTRA like '%auto_increment%'

For Sql Server, use sys.columns and the is_identity column:

SELECT 
    is_identity
FROM sys.columns
WHERE 
    object_id = object_id('my_table')
    AND name = 'my_column'

Assuming MySQL, the EXTRA column will indicate whether it is AUTO_INCREMENT .

| TABLE_CATALOG | TABLE_SCHEMA | ... |          EXTRA | ... |
-------------------------------------------------------------
|           def |   db_2_00314 | ... | auto_increment | ... |

And for MSSQL, see here .

Run: describe 'table_name'; In column EXTRA is what you looking for

this works for sql server:

Select COLUMN_NAME, TABLE_NAME
    from INFORMATION_SCHEMA.COLUMNS
    where TABLE_SCHEMA = 'dbo'
    and COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') = 1
    order by TABLE_NAME

In Postgres, try this:

SELECT column_default
FROM information_schema.columns
WHERE
    table_name = 'my_table'
    AND column_name = 'my_column';

And look for something like this (as opposed to NULL ): nextval('my_schema.my_table_my_column_seq'::regclass)