试试下面查询，看结果是否是你需要的

SELECT TAB.NAME AS TABLE_NAME
      ,COL.NAME AS COLUMN_NAME
  FROM SYSOBJECTS TAB
      ,SYSCOLUMNS COL
 WHERE COL.ID = TAB.ID
   AND TAB.TYPE$ = 'SCHOBJ'
   AND TAB.SUBTYPE$ IN ('UTAB')
   AND COL.INFO2 & 0x01 = 1
   AND TAB.SCHID = CURRENT_SCHID

https://blog.csdn.net/ai20110304/article/details/123674658?ops_request_misc=&request_id=0d37e390dd494402bbd2aae49f7e3e33&biz_id=&utm_medium=distribute.pc_search_result.none-task-blog-2_blogkoosearch~default-1-123674658-null-null.268^v1control&utm_term=%E8%BF%90%E7%BB%B4&spm=1018.2226.3001.4450