查询数据库表的所有字段(MySQL、Oracle) MySQL SELECT column_name, column_comment FROM information_schema.COLUMNS WHERE table_name = '表名' AND table_schema = '库名'; Oracle SELECT * FROM SYS.ALL_TAB_COLS WHERE TABLE_NAME = '表名';