--查找数据库中存在自增列的表名及自增列名：
SELECT OWNER,OBJECT_NAME AS TABLE_NAME,NAME AS COLUMN_NAME
FROM SYSCOLUMNS, (SELECT OBJECT_ID,
OWNER,
OBJECT_NAME
FROM DBA_OBJECTS
WHERE OBJECT_TYPE = 'TABLE'
AND OWNER NOT IN ('SYSAUDITOR',
'SYS',
'SYSJOB'))
WHERE ID = OBJECT_ID
AND INFO2 = 1;

--通过函数查看表上自增列的信息：