代码生成部分查询数据库表优化建议

[fengderongyan]

目前代码生成关联的是user_tables , user_tab_comments , user_objects uo这三张表，其实user_tables 这个可以去掉，就关联两张表就能满足目前需求。 select dtc.table_name, dtc.comments as table_comment, uo.created as create_time, uo.last_ddl_time as update_time from user_tab_comments dtc, user_objects uo where dtc.table_name = uo.object_name and uo.object_type = 'TABLE'

[yangzongzhuan]

你可以PR上来看看。