您好，可通过该sql进行判断哪张表哪个字段是自增列：

select
        s.name    ,
        c.name ,
        c.type$,
        c.info2
from
        sysobjects s,
        syscolumns c
where
        s.id    =c.id
    and c.info2 =1
    and s.name in
        (
                select table_name from dba_tables where owner='SYSDBA'
        ) ;

感谢@Song Junjie回复
参考你提供的语句写了如下查询：

new DmCommand($“BEGIN IF EXISTS (SELECT S.NAME,C.NAME FROM SYSOBJECTS S, SYSCOLUMNS C WHERE S.ID=C.ID AND C.INFO2 =1 AND S.NAME = ‘{tableName}’) THEN SET IDENTITY_INSERT “{tableName}” ON; END IF; END;”, connection).ExecuteNonQuery();

仍然会出现：表 *** 不存在IDENTITY列 的错误

只好拆成了两条语句执行，执行成功：

var hasIdentity = (long)new DmCommand($“SELECT COUNT(*) FROM SYSOBJECTS S, SYSCOLUMNS C WHERE S.ID=C.ID AND C.INFO2 =1 AND S.NAME = ‘{tableName}’;”, connection).ExecuteScalar() > 0;
if (hasIdentity)
{
    new DmCommand($“SET IDENTITY_INSERT “{tableName}” ON;”, connection).ExecuteNonQuery();
}

对相关的SQL语句不熟悉，感觉IF EXISTS没有正确使用。